I have a problem and hope someone on this site will be able to help?
On 1 spread sheet I have a list of Advisors and an errors they have made
Ie
USER Date Reason
RM 04/08/08 not input name
RM 05/08/08 incorrect address
ST 01/08/08 wrong DOB
EL 05/08/08 criminal act
RM 06/08/08 wrong DOB
Is the any formula that I use to look up the user and then copy all of the other info across to a 2nd spreadsheet?
I hope this is clear if not I will try and explain further.
Many thanks in advance
Bookmarks