Hi,
I need your help, I have recently branched out doing a bit of work as myself rather than working for the machine and I need some help creating a workbook that will help with quotes and invoice.

I have a workbook where I fill in the timesheet sheet then the quote sheet and invoice sheet are then filled in with the use of simple formula. This is then emailed to the company. (All three sheets get emailed together in one go for them to print)

I would like to change they way I do this some way so I also have a master workbook which I keep with my timesheet data for the year, I have thought of 2 ideas:
1,creating a blank workbook for the year with just 52 timesheet tabs on then exporting the data to the other workbook where it would produce the quote and invoice sheets ready to email to the company I did the job for.

2, create a master workbook or form that can produce the timesheet, quote and invoice by exporting from a sheet of data with the 52 weeks each as a row in a separate workbook and /or saved as three PDF documents to email out.

The only problem is I’m not sure how to do either, can someone help me or do they know a better way???


Please help.
Andy