Hi,

Hopefully this is a fairly simple prob for clued up people .... unlike me !!

I am trying to sort out an order form for my wife. To mark the end of the order list (col C) I have the text "NONE". What I want to do is find this text in the column, (say cell C20) and do a number of things .....

Copy its content ("NONE") into the next row (ie C21)
Copy the name of the purchaser (cell D10) into the original "NONE" cell (C20).
Copy order No (dependant on row position - ie B20).

I already have a cell with the value of the row position in, if it helps (ie Cell F1=20). The idea is that so I can hit a button, to replace on "NONE" row, with info about the order and put "NONE" into the next row, ready for the next order. Obviously, the row position of "NONE" changes on each visit.

I hope this makes sense ??

Many thanks in advance,
Ross