Jak
Well-known Member
- Joined
- Apr 5, 2002
- Messages
- 833
I need assistance with a macro.
I have a macro that copies the active worksheet, opens a new worksheet and paste the copied sheet.
What I also need the macro to do is assign todays date in the left hand portion of the footer. Assign the time to the right hand portion of the footer.
I then need a user promp that takes a mixture of letters and numbers and assigns the digets to the new sheets tab and to the sheets header.
Any ideas or code would be appreciated.
This message was edited by Jak on 2002-05-15 06:26
I have a macro that copies the active worksheet, opens a new worksheet and paste the copied sheet.
What I also need the macro to do is assign todays date in the left hand portion of the footer. Assign the time to the right hand portion of the footer.
I then need a user promp that takes a mixture of letters and numbers and assigns the digets to the new sheets tab and to the sheets header.
Any ideas or code would be appreciated.
This message was edited by Jak on 2002-05-15 06:26