LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,560
Default Offset Formula or Better Way

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Offset Formula Sean Excel Worksheet Functions 1 October 5th 08 06:05 PM
Compare Cell Values, Offset(-1,0), Offset(-1,-1), and xlFillDefaul RyGuy Excel Worksheet Functions 2 September 28th 07 10:54 PM
Offset formula jostlund Excel Discussion (Misc queries) 4 May 23rd 07 04:01 PM
Offset in Formula Joey Excel Discussion (Misc queries) 1 November 12th 06 01:23 AM
Help with Offset formula Ken G. Excel Discussion (Misc queries) 2 May 26th 06 02:32 AM


All times are GMT +1. The time now is 10:12 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"