hi all,
I have a main processing file with say 10 sheets. After processing I want to save selected sheets (1, 4 and 5) as a new excel file. The code I have found so far saves each sheet as a separate file, however, I want to combine the selected sheets in one file.
Any ideas?
thanks!
I have a main processing file with say 10 sheets. After processing I want to save selected sheets (1, 4 and 5) as a new excel file. The code I have found so far saves each sheet as a separate file, however, I want to combine the selected sheets in one file.
Any ideas?
thanks!