Search for value in row. if found, copy column formulas into found column range

Hi everyone,

I have a workbook with multiple sheets. In the Intro sheet range M6 is a formula driven value. What I'm trying to do is have a macro which will search through each worksheet in the workbook in row 9, find a matching value to the one in the Intro sheet range M6. When the value is found, it will then copy the FORMULAS (not values) from range("B10:B100") in worksheet Formulas into the found worksheet starting at row 9, offset(3,0) so the paste would start on row 12. Below is the code I currently have. I'm not getting any errors, but its also not finding any values:

Please Login or Register  to view this content.

Any ideas?

Thanks!!

Worked it out. If anyone's interested, I change:

Please Login or Register  to view this content.

to:

Please Login or Register  to view this content.