Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
RobHan
 
Posts: n/a
Default Copying a formula to multiple worksheets

Is there a way to copy a formula to multiple worksheets so that Excel
understands that you don't want to use the first worksheet formula, but the
formula on the preceding worksheet?

Example:

52 sheets (one for each week)
Cell A1 Worksheet 1 = Jan 7 (first week ending date)
Cell A1 Worksheet 2 = =+Sheet1!A1+7, giving Jan 14
If I copy Cell A1 Worksheet 2 to Cell A1 Worksheet 3, I get Jan 14; I want
Jan 21

I want Excel to consider that I'm copying a formula that references a cell
on the previous sheet, so the result should reference the previous sheet, not
the first sheet

Anyone know how to make it work?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Richard Walker
 
Posts: n/a
Default Copying a formula to multiple worksheets

I am facing this exact same scenario. Any Ideas?

"RobHan" wrote:

Is there a way to copy a formula to multiple worksheets so that Excel
understands that you don't want to use the first worksheet formula, but the
formula on the preceding worksheet?

Example:

52 sheets (one for each week)
Cell A1 Worksheet 1 = Jan 7 (first week ending date)
Cell A1 Worksheet 2 = =+Sheet1!A1+7, giving Jan 14
If I copy Cell A1 Worksheet 2 to Cell A1 Worksheet 3, I get Jan 14; I want
Jan 21

I want Excel to consider that I'm copying a formula that references a cell
on the previous sheet, so the result should reference the previous sheet, not
the first sheet

Anyone know how to make it work?

Reply
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
Adding multiple worksheets Craig Excel Worksheet Functions 1 July 6th 05 07:21 PM
Copying multiple Worksheets Dor474c Excel Discussion (Misc queries) 0 June 29th 05 10:10 PM
Formula checking multiple worksheets sonic-the-mouse Excel Worksheet Functions 1 June 6th 05 06:37 PM
Multiple Condition Sumif Formula momtoaj Excel Worksheet Functions 3 April 6th 05 04:06 PM
copying cells from other worksheets yesbob Excel Discussion (Misc queries) 1 February 7th 05 06:18 PM


All times are GMT +1. The time now is 09:46 AM.

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

About Us

"It's about Microsoft Excel"