John Thompson
New Member
Hi All,
I am very much a novice at excel so thankyou in advance.
I have been reading through this forum & trying to make a macro for the attached spreadsheet with no success.
I have manually created the 25 work order sheets while I have been trying to create a macro, what I am trying to acheive is a command button which will create a new work order sheet from the template and also number the sheet, place the work order number into "B2", and link the 'date received", "date completed" & "sub total cost" back to the master sheet, in each sheet and also create a hyperlink on the master sheet from the job no.
Again Thankyou
John
I am very much a novice at excel so thankyou in advance.
I have been reading through this forum & trying to make a macro for the attached spreadsheet with no success.
I have manually created the 25 work order sheets while I have been trying to create a macro, what I am trying to acheive is a command button which will create a new work order sheet from the template and also number the sheet, place the work order number into "B2", and link the 'date received", "date completed" & "sub total cost" back to the master sheet, in each sheet and also create a hyperlink on the master sheet from the job no.
Again Thankyou
John