Transferring Data From A Excel Workbook to Another Automatically

Closed
Legacy1990 Posts 2 Registration date Tuesday December 16, 2014 Status Member Last seen December 18, 2014 - Dec 16, 2014 at 11:38 AM
Legacy1990 Posts 2 Registration date Tuesday December 16, 2014 Status Member Last seen December 18, 2014 - Dec 18, 2014 at 09:05 AM
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 response

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Dec 18, 2014 at 01:52 AM
is it not simpler to save workboo1 as your latest workbook
0
Legacy1990 Posts 2 Registration date Tuesday December 16, 2014 Status Member Last seen December 18, 2014
Dec 18, 2014 at 09:05 AM
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.
0