Copying formula
=OFFSET(SheetB!$G$8,(ROW(A1)-1)*13,0)-
OFFSET(SheetB!$G$7,(ROW(A1)-1)*13,0)+
OFFSET(SheetB!$G$9,(ROW(A1)-1)*13,0)+
OFFSET(SheetB!$G$10,(ROW(A1)-1)*13,0)
--
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"MKH Eyrbakk" wrote in message
...
I have a formula in a worksheet with two sheets, A and B
The formula is in SheetA =SheetB!G8-SheetB!G7+SheetB!G9+SheetB!G10
How can I copy this formula down in SheetA but always getting information
13
rows down in SheetB and then again 13 rows down?
|