Move Data from one workbook to another

[Closed]
Report
Posts
1
Registration date
Wednesday January 1, 2014
Status
Member
Last seen
January 1, 2014
-
Posts
1
Registration date
Tuesday March 11, 2014
Status
Member
Last seen
March 11, 2014
-
Hi

I would like to move data from one workbook to another (copy & paste basically but there's tons of lines). The second workbook is in a different format to the first so a straight copy/paste doesn't really work. I have 80 sheets and manually doing each sheet takes 1hr - so I'm looking for a VBA shortcut. Please help.

2 replies

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
802
Is the other workbook blank?
in that case why not save the first file in the name of second book.
regarding formats depends upon what you want.

this is only a wild suggestion.
Posts
1
Registration date
Tuesday March 11, 2014
Status
Member
Last seen
March 11, 2014

I have the same issue. The 2nd workbook is a template into which data should be pasted. Like column A data of 1st workbook should be pasted in column D of 2nd workbook, columnB in 1st to column N in 2nd...etc Which is the best way to solve this?