For your Q1, here's one way ..

In Sh4,
In B4: =OFFSET('Weekly Input'!$C$3,,COLUMNS($A:A)*5-5)
Copy B4 across to D4. And that will do it.

Success? Celebrate it, click the YES button below

P/s: You should stick to only 1Q per thread. Make it focused and attractive
for responders, increase your chances of getting responses ..
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik
---
"Brad" wrote:
.. Question #1 for Sh4 and problem I have is this;
Week1(b4) =('Weekly Input'!C3)
Week2 (c4)=('Weekly Input'!H3)
Week3 (d4)=('Weekly Input'!M3)
As you can see my formula pulls from cells that advance or change by 5 each
week.
How can I drag the cell formulas across the row and have the formula change
(advance) "just" the letter(column) designation (by 5)correctly? If at all
possible.