Previous Topic Next Topic

Move Data from one workbook to another

Closed
Abu Tahar
Posts
1
Registration date
Wednesday January 1, 2014
Status
Member
Last seen
January 1, 2014
 - Jan 1, 2014 at 07:52 PM
Niv.2
Posts
1
Registration date
Tuesday March 11, 2014
Status
Member
Last seen
March 11, 2014
 - Mar 11, 2014 at 06:52 PM
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.
Related:

2 replies

Answer 1 / 2
venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
 810
Jan 1, 2014 at 11:01 PM
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.
0
Answer 2 / 2
Niv.2
Posts
1
Registration date
Tuesday March 11, 2014
Status
Member
Last seen
March 11, 2014
Mar 11, 2014 at 06:52 PM
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?
0