Excel - Helpdesk

[jsomer2000]

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

 

[onlyadrafter]

Hello,

have you tried using the macro recorder? Have a go, and post any problems you have.

 

[jsomer2000]

I have used the macro recorder - it creates an copy of the sheet and resets new job worksheet. It doesn't rename the worksheet with the correct reference from a particular cell

 

[dave3009]

I think what onlyadrasfter means is to post the code the macro recorder gave you and we can clean it up for you.