Transferring Data From A Excel Workbook to Another Automatically [Closed]

Report
Posts
2
Registration date
Tuesday December 16, 2014
Status
Member
Last seen
December 18, 2014
-
Legacy1990
Posts
2
Registration date
Tuesday December 16, 2014
Status
Member
Last seen
December 18, 2014
-
Hi There,

I'm fairly new at macros and I would like to write a code that will help me transfer data from a workbook to another. I update Workbook 1 every day and I want to be able to automatically transfer my new numbers into my daily report (Workbook 2).

Workbook 1 numbers change everyday and are added to the bottom of a list. I would like to be able to click a button so that the new numbers I get are transferred into workbook 2 automatically.

Does anyone know how I can do this?

Thanks in advance,

Erik

1 reply

Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
790
is it not simpler to save workboo1 as your latest workbook
Legacy1990
Posts
2
Registration date
Tuesday December 16, 2014
Status
Member
Last seen
December 18, 2014

I do for my files but I need to transfer all that data over to my daily report which I send out to everyone in my company. The daily report has a specific layout and I just need to change the numbers everyday.