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
|