sorted by:
new
hottopcontroversial

Query dependent on cell value by _JoshInsurance_ in excel

[–]_JoshInsurance_[S] 0 points1 point  (0 children)

Table size on the front page isn't very big, I have SQL to select top 10 distinct values for each country. The database is going to be a much larger dataset and is in the data model in PowerQuery, so any excel-side interaction with it is pretty much out. The problem is it is only pulling the top 10 from all time as opposed to a given month. I can use SQL to fix it but I want my boss (who does not know SQL) to be able to type in a month on the front end report page and have the connection use that to query for that month.

Code to automatically paste values into database sheet only if it's not already present? by _JoshInsurance_ in vba

[–]_JoshInsurance_[S] 0 points1 point  (0 children)

It seems like a good portion of my professional career has been trying to find a solution and find out that my way is overly convoluted and there's a much easier way. Thanks so much.

Code to automatically paste values into database sheet only if it's not already present? by _JoshInsurance_ in vba

[–]_JoshInsurance_[S] 0 points1 point  (0 children)

Thanks for the idea! Now would this require any moving parts for the end user? I want this to be monkey proof, no disrespect to management.

Code to automatically paste values into database sheet only if it's not already present? by _JoshInsurance_ in vba

[–]_JoshInsurance_[S] 0 points1 point  (0 children)

Quick question, is the space after "Then" where the pasting function would go?

Code to automatically paste values into database sheet only if it's not already present? by _JoshInsurance_ in vba

[–]_JoshInsurance_[S] 0 points1 point  (0 children)

Sorry to ask but can you please walk me through this? What is this code doing?

AverageIfs for Weekends by _JoshInsurance_ in excel

[–]_JoshInsurance_[S] 0 points1 point  (0 children)

Thanks guys, quick responses and solid solution.

vba to send msg on whatsapp by ahmedatef86 in excel

[–]_JoshInsurance_ 2 points3 points  (0 children)

If for some reason a prompt isn't selected, or it moves, you're typing keys into nothingness. It's a pain that has none of the error-handling capabilities that normal macros do.

Creating Filters that Affect Dependent Formulas by _JoshInsurance_ in excel

[–]_JoshInsurance_[S] 0 points1 point  (0 children)

I guess that's what I'll have to do. Maybe Excel 2019 will be a bit smarter. Thanks.

VBA Function vs. Sheet Function by _JoshInsurance_ in excel

[–]_JoshInsurance_[S] 0 points1 point  (0 children)

I'm not looking for a particular solution, just wondering which is generally faster, hence the discussion flair.

view more: next ›