Move Data from one workbook to another

Closed
Abu Tahar Posts 1 Registration date Wednesday 1 January 2014 Status Member Last seen 1 January 2014 - 1 Jan 2014 à 19:52
Niv.2 Posts 1 Registration date Tuesday 11 March 2014 Status Member Last seen 11 March 2014 - 11 Mar 2014 à 18:52
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 14 June 2009 Status Contributor Last seen 7 August 2021 811
1 Jan 2014 à 23:01
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 11 March 2014 Status Member Last seen 11 March 2014
11 Mar 2014 à 18:52
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?