View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
BaggieDan BaggieDan is offline
external usenet poster
 
Posts: 18
Default Find a cell that contains ?? - Log Creation and Updating

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