MrExcel Publishing
Your One Stop for Excel Tips & Solutions

How to automate moving specific info from one spreadsheet to another


Posted by Judy on January 18, 2001 6:40 AM

I have a spreadsheet with all the monthly commission information for the salespeople. I highlight and copy info by salesperson to their own commission statement. Is there a way to automate this?


Posted by Carl on January 25, 2001 5:18 AM

Create a macro then link a button to that macro.
from the Tools drop down select Macros, then select Record new macro, give the macro a name.
Then go thru the motions of selecting, copying and pasteing the data, when thru, go back to Tools, macros and stop recording.
Create a button and link the macro to that button

Posted by Judy on January 25, 2001 9:17 AM

Posted by Judy on January 25, 2001 9:18 AM

Thanks, do you know if there is a way I could change the Sheet names it saves to each month. Such as one month is Dec Statements the next month would be Jan.