Re: Copying certain cells from each row to another sheet for invoice
I managed to have a play with the workbook this morning and got to a point (with simple formulae changes,no coding!) to something that Will be an awesome tool for this company!!
The only issue now lies with clearing the invoice tab (of just the materials and their cost from the sheet when needed) It would be awesome to have a button on the tab to clear the contents. (These content are in cell C19:C39 D19:D39 E19:E39 F19:F39 G19:G39 H19:H39 I19:I39 J19:J39 K19:K39 L19:39)
I have attached the latest file with the changes I have made. I hope it hasn't mucked around too much with your overall model!)
The way i imagine the workbook to work now is...
I enter the stock used
I click "new invoice"
I enter labour charges in the table at the bottom of data tab.
I click onto the template tab.
I print hard copy
I save file
I press "clear invoice" button on template tab.
Reopen last saved file to repeat the process.
hope this makes sense, im sure i can manage for the time being with the model i have, if you are sick of changing this thing for me!