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.

2 responses

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
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.
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?