Macro to find text and if found, copy an adjacent cell into a different cell

[Raulus]

Hi All,
I have been trying to alter various macros for a current problem I am having and so far I have been completely unsuccessful. I require a macro that will look for certain text in a column and then if it finds the text, copy the contents of an adjacent cell into a different cell.

So the macro checks cells in column A for the text "SC", if it finds SC then it will paste the contents of the cell in column H on the same row as the SC text into a cell that is offset 2,6 so in column N and two cells up.

I have attached a work book with a rough example if it helps.

Any help would be greatly appreciated as I have been racking my brains all morning and searching everywhere for a solution.

Thanks in advance for any help.

[mike7952]

I understand what your wanting to do, but SC is in Column A Row 1 and theres no way to copy Column H to Column N 2 Rows up. So what needs to happen there?

[Raulus]

My apologies Mike, please ignore the first SC in A1 the SC text would only be in cells where it would be able to copy to the offset.
The SC in A1 was meant to be a title but would not be there in the actual spreadsheet, I shouldn't have typed it in A1.

Thank you

[mike7952]

Ok no problem. Try this

Please Login or Register  to view this content.

[Raulus]

That is perfect, thank you very much for your help Mike.