jsomer2000
Board Regular
- Joined
- Jul 12, 2007
- Messages
- 50
Hi there
I am building a basic helpdesk style spreadsheet where I want to monitor IT jobs.
I have a worksheet called 'New Job' that holds all the basic data of the job. When a new job is required I want to enter the data here. When I have finished entering the data I want to press a button and this runs a macro or VBA program.
I want the macro to copy the worksheet and rename the tab with data in a particular cell on this weeksheet. Then resets all the information on the new job worksheet as this is my template. Ready for the next call.
Any ideas?
Thanks
Nick C
I am building a basic helpdesk style spreadsheet where I want to monitor IT jobs.
I have a worksheet called 'New Job' that holds all the basic data of the job. When a new job is required I want to enter the data here. When I have finished entering the data I want to press a button and this runs a macro or VBA program.
I want the macro to copy the worksheet and rename the tab with data in a particular cell on this weeksheet. Then resets all the information on the new job worksheet as this is my template. Ready for the next call.
Any ideas?
Thanks
Nick C