Grouping Columns & Moving

Hi All,

New to the forum

I have been asked by my work if i would have a go at creating a production workflow sheet, I would like to enter a jobs information so it runs from column A1 to say D1

So my 1st job information would be entered as follows:

A1 = job name - B1 = quantity - C1 = cost - D1 = customer

Then my second job would run in the A2 - D2 columns & row, and so on for the rest of the jobs i need to enter.

What i would like to do is to be able to send a completed job to a second sheet, maybe by colouring the A column of the finished job to red. So if job 3 is finished i would colour A3 red and A3 - D3 would be sent to sheet 2 and removed from sheet 1.

Is this poss at all ? seems very complicated to me but i know you guys are the best at this so if anyone can help !!

Thanks

Emz

Please see the attachment.

The workbook uses an event driven macro which you will find on the Sheet1 tab in the VBA editor (ALT F11).

Put the value Yes into column 5 and the row will move to the second sheet. I've added a date stamp for good measure.