I have a worksheet with my jobs in one tab and proposals in another.

When I win a job I have written a proposal for I want to change a cell in that row to 'won'.

Then I want the macro to add a new row in my jobs work sheet and include the name of the job I have just won in that new row.

Can anyone help please?