Thanks to you both, I don't like asking for code without having a go first
but that, as simple as it now seems, had me stumped for a while.

Cheers!

"JLGWhiz" wrote:

Example code:

Dim rng As Range, sh As Worksheet
Set sh = Sheets("Somesheet")
Set rng = sh.Range("A2", sh.Cells(Rows.Count, 1). End(xlUp))
Set newRng = rng.Find(ABC123, LookIn:=xlValues)
Set col5 = newRng.Offset(0, 4)
Set col6 = newRng.Offset(0, 5)
col5.Select
col6.Select



"BaggieDan" wrote in message
...
I am looking to create a log that has three stages. When the user
completes
the first stage the information is written to a spreadsheet on the next
empty
Row. I know how to do this bit. At a point in the future a different
user
will then complete stage two and the subsequent information needs to be
added
to the existing log.

I can ensure that any different user links to the same spreadsheet but
what
I am struggling on is getting the macro to find the right row. The first
cell in the row will be a unique identifier that will be present
throughout
the three stages.

So what I am asking is the code for : Search Column A for a cell that
contains ABC123. When found select this Row, Column 5, then Column 6 etc
etc.

I hope that is clear and someone is able to help!

Thanks in Advance


.