Macro to update database, Match Cell value from Sheet 1 in Sheet 2 then copy and paste

Hey guys

For the last few days i have been trying to build a macro with limited knowledge, i have looked through countless threads but still not luck

I have a excel spread sheet with Sheet 1 being where all the information is held and the hope is to paste information into sheet 2 and then run a macro which updates sheet 1

I am using some web ranking software which puts out the results in a CSV format and in alphabetical order

What i need to do is search sheet 2 to match a cell value from sheet 1 and then copy a corresponding cell (same row a few cells over) from sheet 2 to sheet 1

this needs to be repeated for every line of sheet 1

any help would be greatly appreciated

Hi

From your description, VLOOKUP should bring back the data you are chasing. Try looking at that function.

If that won't do it, then put up an example file for review.

rylo

Originally Posted by rylo

Hi

From your description, VLOOKUP should bring back the data you are chasing. Try looking at that function.

If that won't do it, then put up an example file for review.

rylo

Thanks for the reply, i will start looking into it now

I've attached a mock spreadsheet,

Its in the same format, as you can see the keyword cell needs to be matched then the 'position' cell copied and pasted

There are hundreds of keywords

Cheers

Hi

Based on your example file, exactly what do you want to copy from where, and put to where? There doesn't seem to be any relationship between the numbers on the 2 sheets.

rylo

Updated the file

Hi

try this

Please Login or Register  to view this content.

rylo

Brilliant!

Thanks a lot mate, really appreciate it