cut and Paste formulae from another sheet into column where row 4="Stat"

**jamiepullen** · 09-25-2008, 04:58 PM

Hi, i have a workbook with 8 sheets. sheet 1 has formulae, sheets 2 to 7 has rows of data that vary from time to time and sheet 8 has instructions to the user. I would like a macro if anyone can help that will scan across the columns on sheets 2 to 7 until it reaches a column with "stat" on row 4. i want it to then copy the 10 or so columns of formulae on sheet 1 and paste it starting at the column after the column with "stat" on row 4.

I was hoping that the formulae would apply to the new sheet, ie if i had on the formulae sheet in cell B2 "=A2" and it was pasted to Z2, it would now be "=Y2"

Is this possible?

**shg** · 09-25-2008, 05:07 PM

Please edit your thread title to be usefully descriptive of your problem. "Row 4 = Stat" is not something that's likely to enhance the searchability of the forum.