the jobs that are in progress are filled with yellow. each time the workbook
is opened, i want it to create a new sheet (overwriting the old one) that
fills in all the current jobs (yellow).

the difficult part is that a job may be more than one row. each job is
seperated by a thick black line.

so in the end, it needs to copy over each job (from black line to black
line) that is filled in with yellow. also, the rows A2:O6 would need to
copied (title and headings)

to do it when the document opens, i use:

Private Sub Workbook_Open()

right?

thanks