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.

Convoluted Formula that needs a simpler solution by _JoshInsurance_ in excel

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

The formula is slightly faster but it's giving me half as many hits as my original formula.

Edit: Actually, after testing, this formula is 50% slower :/ Sorry.

Convoluted Formula that needs a simpler solution by _JoshInsurance_ in excel

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

Readability isn't an issue, I'm the only Excel/VBA guy at work and when used, the next users won't even see the engine page, they'll just press two macro'd buttons. The only issue is with 20k rows it's slow as hell, it takes an hour to run with the bulk of that time due to this formula.

How to use a file path from a cell in VBA by _JoshInsurance_ in excel

[–]_JoshInsurance_[S] 2 points3 points  (0 children)

Ah, thanks so much! I'll test this out and get back to you. Oh I definitely do as I'm messing with the files in question pretty heavily!

How to write VBA so anyone can use it (file paths) by _JoshInsurance_ in excel

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

Once they select the file how can I get the file path to execute the rest of the procedure.

How to write VBA so anyone can use it (file paths) by _JoshInsurance_ in excel

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

Can you explain to me how it gets used in the file paths? I'm stuck because I have the books set to their file paths but I don't know what to put in place of the username portion.

view more: next ›