I have excel sheet #1 that has 308 fields with text (A1 through A308) and 308 fields of numbers (B1 through B308). A1 correlates to B1 and on down the line.
I have excel sheet #2 that has 9218 fields of text (A1 through A9218). These text fields are populated with identical text from excel sheet #1, except obviously it repeats more than once and isn't in the same order as excel sheet #1.
I need someone who can take the relationship from excel sheet #1 and apply it to excel sheet #2 by replacing the text fields in excel sheet #2 with its corresponding number from excel sheet #1.
I could do this by copying A1 from Sheet 1 and going to Sheet 2 and running a replace option and pasting that A1 text from Sheet 1 and replacing it with the number from sheet 1, field B1 and then replacing all and repeating this procedure 308 times, but I'd rather not.
44 freelancers are bidding on average $34 for this job
Hello... I can do this job for you in a few hours without any mistakes. Quality, honesty, accuracy are my keywords. I am available through skype also... Hope to work with you, thank you