K
Khalil handal
Hi,
I have a sheet with the name of: June 2006
In an other sheet called (Report) in the same workbook in cell C25
I have the following formula: ='June 2006'!E$160*'June 2006'!$D$1+'June
2006'!F$160
I need to copy that formula to the next 73 cells (aproximatly) leaving lines
for subtotal between.
to clarify:
C26 will have: ='June 2006'!G$160*'June 2006'!$D$1+'June 2006'!H$160
C27 will have: ='June 2006'!I$160*'June 2006'!$D$1+'June 2006'!J$160
C28 will have: ='June 2006'!K$160*'June 2006'!$D$1+'June 2006'!L$160
.................. ...........
............................
The last cell will have the formula of:
='June 2006'!EG$160*'June 2006'!$D$1+'June
2006'!EH$160
Is there an easy way to do it? I am going to do this for 12 sheets (12
months).
I have a sheet with the name of: June 2006
In an other sheet called (Report) in the same workbook in cell C25
I have the following formula: ='June 2006'!E$160*'June 2006'!$D$1+'June
2006'!F$160
I need to copy that formula to the next 73 cells (aproximatly) leaving lines
for subtotal between.
to clarify:
C26 will have: ='June 2006'!G$160*'June 2006'!$D$1+'June 2006'!H$160
C27 will have: ='June 2006'!I$160*'June 2006'!$D$1+'June 2006'!J$160
C28 will have: ='June 2006'!K$160*'June 2006'!$D$1+'June 2006'!L$160
.................. ...........
............................
The last cell will have the formula of:
='June 2006'!EG$160*'June 2006'!$D$1+'June
2006'!EH$160
Is there an easy way to do it? I am going to do this for 12 sheets (12
months).