Copying from dynamic workbooks
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.
|