software

As I drag the formulas below across multiple coulmns on the quot;Time Sheetquot; tab,
is there a way to have the row reference for each update by 65? The data on
the Activity Sheet tab is arranged down the tab while the summary on the
quot;Time Sheet tab goes across the tab.

Thanks
David

= 'Activity Sheet'!$C8 --gt; = 'Activity Sheet'!$C73 --gt; = 'Activity
Sheet'!$C138
= 'Activity Sheet'!$C13
= 'Activity Sheet'!$C18
= 'Activity Sheet'!$C23
= 'Activity Sheet'!$C28
= 'Activity Sheet'!$C33
= 'Activity Sheet'!$C38
= 'Activity Sheet'!$C43
= 'Activity Sheet'!$C48
= 'Activity Sheet'!$C52
= 'Activity Sheet'!$C56
= 'Activity Sheet'!$C64
You'd have to use the offset() function

=offset('Activity Sheet'!$C8,(column(A1)-1)*65,0)

Use that in place of

= 'Activity Sheet'!$C8

amp; copy it over

quot;Davequot; wrote:

gt; As I drag the formulas below across multiple coulmns on the quot;Time Sheetquot; tab,
gt; is there a way to have the row reference for each update by 65? The data on
gt; the Activity Sheet tab is arranged down the tab while the summary on the
gt; quot;Time Sheet tab goes across the tab.
gt;
gt; Thanks
gt; David
gt;
gt; = 'Activity Sheet'!$C8 --gt; = 'Activity Sheet'!$C73 --gt; = 'Activity
gt; Sheet'!$C138
gt; = 'Activity Sheet'!$C13
gt; = 'Activity Sheet'!$C18
gt; = 'Activity Sheet'!$C23
gt; = 'Activity Sheet'!$C28
gt; = 'Activity Sheet'!$C33
gt; = 'Activity Sheet'!$C38
gt; = 'Activity Sheet'!$C43
gt; = 'Activity Sheet'!$C48
gt; = 'Activity Sheet'!$C52
gt; = 'Activity Sheet'!$C56
gt; = 'Activity Sheet'!$C64
gt;
gt;