levanduski00
New Member
- Joined
- Sep 18, 2002
- Messages
- 2
First let me begin by mentioning that I'm a complete beginner, but I very much want to learn to program macros to make my life easier at work.
My current project requires that I take four specific worksheets out of a workbook of 20 sheets and create a new workbook saved as "MMM_DD" format. For example "Oct_01". The date would be obtained using a cell refence from one of the copied worksheets.
I used the macro recorder to do most of the programming, however I'm very unclear how I can use the information from a specific cell to specify the filename. The refernce cell is a date, and I want to save the file by date.
Please let me know if you have any suggestions or if you need more information regarding my situation.
Thanks,
Roger
My current project requires that I take four specific worksheets out of a workbook of 20 sheets and create a new workbook saved as "MMM_DD" format. For example "Oct_01". The date would be obtained using a cell refence from one of the copied worksheets.
I used the macro recorder to do most of the programming, however I'm very unclear how I can use the information from a specific cell to specify the filename. The refernce cell is a date, and I want to save the file by date.
Please let me know if you have any suggestions or if you need more information regarding my situation.
Thanks,
Roger