How to reference an offset from a cell?
 

I have timesheet data in one sheet with 10 rows for each week (day
detail + totals).
I have a 2nd sheet that pulls totals from the first so I can generate
an analysis of my time and earnings.

The formula I am using on rows of my analysis is:
B7 =Timesheet!$F$11
B8 ==Timesheet!$F$21
B9 ==Timesheet!$F$31
etc...

Is there a way to create a formula so that I can say for B10 it is the
location referenced in B9 + 10 rows? It would be nice to have a
formula so I don't have to hard code each cell.

I have spent hours trying lots of things using the Excel Help, but I'm
a bit of a novice when it comes to formulas.
If anyone can help I would appreciate it.
Thanks in advance.
Tony

How to reference an offset from a cell?
 

This worked for me:

=INDIRECT("'timesheet'!f" & 10 * ROW(A1) + 1)


"poddys" wrote:

I have timesheet data in one sheet with 10 rows for each week (day
detail + totals).
I have a 2nd sheet that pulls totals from the first so I can generate
an analysis of my time and earnings.

The formula I am using on rows of my analysis is:
B7 =Timesheet!$F$11
B8 ==Timesheet!$F$21
B9 ==Timesheet!$F$31
etc...

Is there a way to create a formula so that I can say for B10 it is the
location referenced in B9 + 10 rows? It would be nice to have a
formula so I don't have to hard code each cell.

I have spent hours trying lots of things using the Excel Help, but I'm
a bit of a novice when it comes to formulas.
If anyone can help I would appreciate it.
Thanks in advance.
Tony

How to reference an offset from a cell?
 

Well, the OFFSET() function is what you need. In B7 put

=OFFSET(Timesheet!$F$11,10*(ROW(A1)-1),0)

& copy it down

"poddys" wrote:

I have timesheet data in one sheet with 10 rows for each week (day
detail + totals).
I have a 2nd sheet that pulls totals from the first so I can generate
an analysis of my time and earnings.

The formula I am using on rows of my analysis is:
B7 =Timesheet!$F$11
B8 ==Timesheet!$F$21
B9 ==Timesheet!$F$31
etc...

Is there a way to create a formula so that I can say for B10 it is the
location referenced in B9 + 10 rows? It would be nice to have a
formula so I don't have to hard code each cell.

I have spent hours trying lots of things using the Excel Help, but I'm
a bit of a novice when it comes to formulas.
If anyone can help I would appreciate it.
Thanks in advance.
Tony

How to reference an offset from a cell?
 

Thanks Duke - that works perfectly.
I just couldn't figure this out without help, but now I have already
sorted out other cells using the same.
Appreciate your help.
Tony