Enter simple changing formula in many but not all cells

[Burley]

Excel 2003
Please forgive me if this is not explained very well, I am totally new to VBA but need to solve a problem..
I have to enter a large number of simple formulas on a worksheet (sheet2), the formula is dependant on where it's being entered. eg.
in Sheet 2 cell E6 the formula would need to be =+Sheet1!$A6*Sheet1!E6 and in Sheet 2 cell h9 it would be =+Sheet1!$A9*Sheet1!H9 and Sheet 2 cell bd53 would be =+Sheet1!$A53*Sheet1!bd53 and so on...
However, I don't want that formula in every cell, only in cells where there is a number in the corrasponding cell in Sheet 1.
I have no idea if that makes sense, but the reason I can't do it by hand is the sheet is massive C3:IV2000!! although most of the cells are blank.

Sorry if i'm asking too much or in the wrong way, but any help would be greatly appreciated

Paul

[VBA Noob]

Burley,

Solved elsewhere

Please don't cross post (read forum rules below) and then delete the post when you find an answer.

Share the answer with other readers

VBA Noob