Hello,
I am new to VBA code and I am trying to automate a report where a slicer for Market data selects one at a time and copies the entire sheet to a new workbook naming each sheet as the market selected in the slicer. I have tried a couple variations of loops and it keeps breaking. I usually use Excel 2013 but for this report it has to be done in 2010. Does anyone know how to do this?
Thank you!
Bookmarks