Michael Dobbins
asked on
Find and Replace in separate column
I am trying to add a find and replace feature to look for an invoice number matching what is in range C7:C28 on sheet 1, with what is in column A on Sheet 4. If there is a match, I need it to copy the text adjacent to the invoice number on sheet one in range D7:D28 into column N on Sheet 4, on the same row the matching invoice number was found. So, if Invoice # 1234 was found on sheet 4 in A5, N5 should be changed to the text from sheet 1. I am new to this so hopefully my description is adequate. if not, I can answer any questions.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Subodh Tiwari, that worked perfectly!! thank you!!
You're welcome Michael! Glad it worked as desired.
Can you upload some sample data?