Find word in one cell and copy cell above in other column

Hi, kurtwagner,

you could either use Find which would deliver a Range-Object if the searched item is found (and the use the row of that range to build the range to copy the values, you may refer to the VBA-Help on that topic) or Application.Match which would either deliver an error or the row number which then could be used as before.

Ciao,
Holger

hi kurtwagner. there are many assumptions & questions involved here, so i suggest you upload a sample Excel file for us to help you better.

1. which column is sure to be filled (so that i can identify the last row)?
2. which row do you start in?
3. do you want to find the exact word "NF" or whether the cell contains "NF"?
4. if row 2 & 3 contains "NF", row 2 will be based on row 1's data & row 3 on row 2's data? so they actually all have the same data for this case?

for exact word:

Please Login or Register  to view this content.

for finding cell that contains "NF":

Please Login or Register  to view this content.

assumptions were that i can find last row in column B & data starts from row 2