Hello,
Looking for some guidance as I am a complete newb when it comes to PowerBI and Power Query..... Here is my dilemma
Looking for some guidance as I am a complete newb when it comes to PowerBI and Power Query..... Here is my dilemma
- I have a workbook that has 50 (US states) sheets plus 4 summary sheets
- I have written (with the help from Joe & Fluff) VBA macro that goes and looks at the cell color
- If cell color matches the criteria, then it copies over to the appropriate summary sheet
- It currently overwrites all the data on the summary sheet
- Currently the macro takes 15 mins to run for one summary sheet