Thread: Copying formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default 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?