I'm writing a code that once you click on one button, it:
Filters values in a table based on a combobox value (the first column of these filtered value is the name of my sheets)
Creates a new blank workbook named from the combobox & another cell in my workbook
Select all the sheets whose names are presents in the filtered value ("C" Column)
Copy Paste the selected sheets in the workbook created in 2
Saves and closes workbook 2
back to workbook 1 and removes filters
I can't seem to make 3) and 4) working, I either copy all sheets (regardless of the filter), either (current code) copies only the last one.
Please see the code below, thanks in advance!
Please Login or Register to view this content.
Bookmarks