I wonder if anyone can help – I have 2 separate spreadsheets within the same workbook.

Sheet1 contains several rows of basic data.

Sheets2 contains a single row of formulas which calculates based on the first row of data in Sheet1.

Using VB I would like to

__count__the number of populated data rows in Sheet1.

Using this "count" I would then like to

__copy__the formula row in sheet2, and then

__insert copied cells__beneath the equivalent number times.

E.g. I have

__30__rows of data in sheet1 – I would like the same number of formula rows displayed in Sheet2 from running Macro.

Any help would be much appreciated.

Phil