Hi
I have a worksheet that I get everyday from someone, and it has a name based on the date on which it is received. So if i get that file today the worksheet will be having a name as 27_April_2012_Datasheet, and if i get it tomorrow it would be 28_April_2012_Datasheet and so on and so forth. Can it be copied to a new sheet say sheet1?
Help would be really appreciated.
Thanks,
Abhushan.
Bookmarks