Copying from dynamic workbooks

  • Thread starter Thread starter drinese18
  • Start date Start date
D

drinese18

Does anyone know of a way to copy from a workbook that is constantly updated
everyday, the thing a new workbook is created everyday based on a date, what
I would like to do is to create a macro that would copy the data from the
most recent workbook. For instance if todays workbook to copy from is labeled
2008-0218, then I would like it to copy all the data within that to a master
workbook, then the next day comes and a new workbook is created labeled
2008-0219, I want to copy from that one as well and it goes on everyday. I
don't want to delete the data that is already there, just to append to whats
already there, so if anyone know's of a way to do this, any help would b
appreciated.
 
Hi!
I imagine you could search up from the bottom of each worksheet until you
find a row that contains content (this is easier/quicker if you know
something is inside the first 20 columns or so). Then you can paste in the
last row without content.

Use dir to find the newest workbook in the folder.

HTH,
Birgit
 
Do you by any chance know how to code it probably, because I want to have it
programmatically do so
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Protection 2
Pulling data from one workbook to another one using VBA 0
How to append data from different sheet and different workbook? 2
copy data from one excel workbook to another workbook using macro 4
Save specific sheets to new workbooks adding tomorrow's date to na 1
Excel Move or Copy Stopped Working? 0
Problem copying between worksheets 2
Excel Copy cells from one worksheet to another workseet - increment row & do again 0

Back
Top