Create new excel file from existing Excel file. [Closed]

Report
-
 Blocked Profile -
Hello,
I want to create a command button in a existing excel file that will pop-open a new excel file. (it will be good if it ask me "Save as" for where to save new file)
The existing file have 6 spreadsheets,
But in the newly created excel file I want to have only 4 spreadsheet copied completely from existing spreadsheet without altering the format.

I am new in excel macros any help will be very much appreciated.

1 reply


So, you only want four of the six TABS copied in the new file?

We really cannot complete tasks such as these turnkey, for these very reasons above. We will spend time (we are volunteers) and energy developing some solution, and they are never QUITE right, and they continue beyond the scope of the original project!

That doesn't mean that an Excel EXPERT won't come along because he likes to help, and he likes challenges even more! It does happen.

I can see an easy process: copy, paste, rename alter, Delete tabs in alter.

But that is me!

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!