Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Offset Formula | Excel Worksheet Functions | |||
Compare Cell Values, Offset(-1,0), Offset(-1,-1), and xlFillDefaul | Excel Worksheet Functions | |||
Offset formula | Excel Discussion (Misc queries) | |||
Offset in Formula | Excel Discussion (Misc queries) | |||
Help with Offset formula | Excel Discussion (Misc queries) |