Offset Formula or Better Way

[David]

I have an sheet with dates for all the Sundays for 2009 in Column G, starting
in row 4. I have 30 sheets label T1 to T30 that I want to insert the dates
starting with the first date in Column A, row 70, the next date in Column A,
row 80, and going every ten rows until all the dates have been created.

Each Txx (T1 to T30) sheet are the same, except they are for different
people. I have currently weekly data in rows that I want to copy/paste to the
rows corresponding to the dates. For example, the first date on row 70,
Column A is 1/4/2009. When I create the date, I also want to copy past the
following rows from the current sheet:
$C$16:$I$16 to C70:I70
$C$18:$I$19 to C71:I72
$C$22:$I$23 to C72:I74
$C$26:$I$29 to C75:I78

When the next date is created in row 80, I need the same data but pasted
starting with row 80. I need this done with all the dates.

I've tried doing it manually with copy/paste with an offset formula, but I
have to change the offset number by one every ten cells. Looking for a macro
to help automate the process with 52 sets of data for 30 sheets.

 

[Max]

One formulas play which gets you through your 1st query below
(keep it to one query per post)

Assume the sunday dates are in Sheet1, in G4 down
Group the sheets T1:T30
Then in T1,
Put in A70:
=IF(MOD(ROWS($1:1)-1,10)=0,OFFSET(Sheet1!$G$4,INT((ROWS($1:1)-1)/10),),"")
Copy down as far as required. Freeze it with an "in-place" copy n paste
special as values. Ungroup the sheets. Done.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:21,000 Files:365 Subscribers:65
xdemechanik