Copy cells from a row to a new table based on cell value

Hi there,

I am new to the boards and need some coding help.

I am compiling a spreadsheet that consists of 2 work sheets, "Quoted works" and "Current Works".

I have done some very simple conditional formatting for colour schemes.

When jobs on the "Quoted Works" sheet the "Status" column becomes "Approved" I would like specific data to be copied into a new job in the "Current Works" sheet.

The cell data that would need to move over to the "Current Works" sheet would be:

- Status (Approved)
- Job#
- Logged By
- Log Date
- Responsible
- Description

The above column headers are replicated in both sheets.

The rest of the sheet would remain blank for the user to manually enter.

We would also need to manually enter jobs (rows) as not all jobs go through the quoted works process.

I have attached a sample worksheet as an example.

Can anyone help me with this or give me some pointers to start me off as it is way beyond my skillset.

FYI I am using Office 2003 but it also needs to be compatible with Office 2010.

Thanks!!

Michael