Hi everyone,
I'm trying to automate a copy/pasting of a row of information from one spreadsheet to another every day (and to realize the daily date changes).
Here's a typical walk-through example:
1. Open up \\Stats\2012\Jan\1.1_file.xlsx
2. Copy row 88 (this is static and doesn’t change)
3. Open up \\Totals\AnnualFile.xlsx
4. Click a the “Daily Sheet” tab
5. Paste the information into the corresponding Date row (such as “Sunday, January 01, 2012”)
6. Save file
I need it to do the logic on its own. I’m learning VBA as I go, but this one is over my head so far. Any help is appreciated!
Thank you!
-Mike
Bookmarks