VBA Code to Create New Worksheet from Existing Template, Populate new WS from Existing WS Template

[dcoker]

This is my first post, so bear with me.

I have a data WS "Timesheet" that is an employee time sheet using each row as a date. I need to create a new billing invoice WS based off of an existing invoice template "Invoice" and label it as the PO Number with the following:

1) Label the new billing invoice WS from the PO number in "Timesheets" range "F7" (The first row of the table).
2) Search Column F for any additional dates with the same value from Column F and compile into the same new billing invoice WS, until the last row of the table is reached.
3) If the next row has a new PO, (Column F again), generate a new billing invoice, if the PO has already been generated, skip this row.

While creating the new Invoice WS's, I need each Invoice to contain data from the "Timesheet" WS that corresponds with each PO row.
Example:

Timesheet Column F value = new billing invoice cell "R3".
Timesheet Column H value = new billing invoice cell "D5".

Each date appears on the invoice as well, and the time from the timesheet would need to correspond with the time for each date on the billing invoice.


I have attached JPG's of a blank Timesheet WS and blank billing invoice WS.

I hope this makes sense.

Thanks for the help.

https://www.dropbox.com/s/qez87krjzh...ample.JPG?dl=0


https://www.dropbox.com/s/ojbqqylxaf...ample.JPG?dl=0