Hi All,
I'm hoping to get some help in running a macro. My situation is this:
I have a master spreadsheet with 13 different tabs. 3 of the tabs are "Today", "Yesterday", and "Statement."
I run 2 reports each morning, "Today" and "Statement."
First, I copy the info from "Today" from the Master Spreadsheet, and paste it into "Yesterday."
I then, after having run "Today" and saving it down in Excel format on the communal drive, copy and paste it into tab "Today."
Again after having saved it down on the communal drive, I copy and paste "Statement" into the "Statement" tab on the Master Spreadsheet.
With all of the new information I needed and now have, a tab checks the numbers on each of the spreadsheets pulled from those main tabs using VLOOKUP. I can be assured the numbers are now correct.
If I can run a macro to pull these reports and paste them in the appropriate tabs, that would be ideal! Thanks for any help!
I'm hoping to get some help in running a macro. My situation is this:
I have a master spreadsheet with 13 different tabs. 3 of the tabs are "Today", "Yesterday", and "Statement."
I run 2 reports each morning, "Today" and "Statement."
First, I copy the info from "Today" from the Master Spreadsheet, and paste it into "Yesterday."
I then, after having run "Today" and saving it down in Excel format on the communal drive, copy and paste it into tab "Today."
Again after having saved it down on the communal drive, I copy and paste "Statement" into the "Statement" tab on the Master Spreadsheet.
With all of the new information I needed and now have, a tab checks the numbers on each of the spreadsheets pulled from those main tabs using VLOOKUP. I can be assured the numbers are now correct.
If I can run a macro to pull these reports and paste them in the appropriate tabs, that would be ideal! Thanks for any help!