Hi guys,

i'm extremely new with Macros but i just wondered if someone could help with a problem which i need completed urgently,

basically i have around 4000 i.d fields which need updating and to do this manually would take a long time so im looking for a way to complete the following action:

COPY "M2" Find "N2" , then paste "M2" into the 'left' field of the search result (the search will find a field in the C column however i want the M2 to be pasted into the B column to the left of the result), is this possible at all?

i have 4000ish of these so i need the macro to then do M3, M4, M5 ect..

thank you,

sorry for my basic understanding of these but any help would be so appreciated.

Stephen