Tech Support Guy banner
Status
Not open for further replies.
1 - 1 of 1 Posts

·
Registered
Joined
·
1 Posts
Discussion Starter · #1 ·
Hi,

I need a macro to save a new excel spreadsheet on my C drive. But before it does that I want the export and the import data on two separate tabs for this new spreadsheet (ss). Please see the file attached:

So I would like to have export info from cell A3 to H7 from the Canada tab and then cell A3 to H 16 on the East tab and so on and so forth for the remaining regions. This would get on the 1st tab for the new ss that will get copied over to my c drive.

So I would like to have import info from cell A10 to H14 on the Canada tab and then cells A19 to H34 copied from the East tab on the new ss. This would be the 2nd tab on the new ss that will get copied over to my c drive.
 

Attachments

1 - 1 of 1 Posts
Status
Not open for further replies.
Top