Search offsetting if and copy and paste

[flynch]

Hello,

I have a huge table of place names and corresponding data. I now have an update for this data (these have been entered underneath the table) and need to to copy them in for the individual place names.

Therefore, for London for example, I would like to search the whole spreadsheet and look for london. When it finds london, I would like to move to the next cell along (one place to the right) and paste the data contained within cell E100.

I don't want it to look and change any of the data below the table (the recent updates) therefore I only want it to search down to row 92 and column BK.

I'm not too great at macros so if anyone can help me out with this - I'd be super grateful.

Thank you

 

[My Aswer Is This]

I don't know what to say. It works for me.
Now if your searching for "London" you must have "London" in quotes like:

"London"
In the script

Not like London


It looks for London