Search results

:)Thanks Luke! I knew there had to be a way to get that count into the code, but I have never dealt with collections before. Looks like a great new learning experience! Jake

The problem as I see it is that the number of variables can change. I am probably making this harder than it needs to be. If the last row is 10 I can set the code to get 10 different variables, but next month there might be 12 and I don't know how to get that value to change.

Greetings all, I have a report that I am attempting to modify to allow the end user have more input into running it. I am importing data from a SQL Database and filtering and massaging it to get it into the correct format. Some items need a different multiplier used to achieve the desired...

Greetings All I am trying to add a top 20 / bottom 20 set of graphs to a dashboard but I find that for some SMALL values, I have multiple instances so when I bring them in the items represented, I only get the first instance repeated for each using the INDEX(MATCH()). Is there a way to get...

Hi I'm Jacob and I'm using Excel 2010 at work where I provide management with ad hoc reports as well as weekly production reports. Using some VBA to automate some repeat reports, and wanting to gain more knowledge in that area as well as learning more about various functions that I am just...