I have 34 worksheets within a workbook and I have hit a bump in the road....

On the second sheet, i have made a forumla to pull in data from certain
cells on sheet 1.......if sheet 3 is the same setup as sheet 1 (different
data) and I want sheet 4 to have the same formulas as sheet 2, only referring
to sheet 3....if this doesnt make sense, I have placed an example below:

='WEEK 1'!B7 pulling in the data in the B7 cell of the worksheet titled
WEEK 1....if i copy the formula to a different sheet, it says the same
formual, but I actually want it to go in numeric order....so the next formula
i want to say is ='WEEK 2'!B7 then ='WEEK 4'!B7 WEEK 1 is its own
sheet.....RESULTS 1 is the sheet pulling in data ....then WEEK 2 is another
sheet.....and RESULTS 2 needs to pull in data from WEEK 2, not WEEK
1.......anyone know how to get this pasted over, or a different way so I dont
have to manually type in the formula for all 17 sheets?

thanks
Kris

Kris Wrote:
I have 34 worksheets within a workbook and I have hit a bump in the
road....

On the second sheet, i have made a forumla to pull in data from
certain
cells on sheet 1.......if sheet 3 is the same setup as sheet 1
(different
data) and I want sheet 4 to have the same formulas as sheet 2, only
referring
to sheet 3....if this doesnt make sense, I have placed an example
below:

='WEEK 1'!B7 pulling in the data in the B7 cell of the worksheet
titled
WEEK 1....if i copy the formula to a different sheet, it says the same
formual, but I actually want it to go in numeric order....so the next
formula
i want to say is ='WEEK 2'!B7 then ='WEEK 4'!B7 WEEK 1 is its
own
sheet.....RESULTS 1 is the sheet pulling in data ....then WEEK 2 is
another
sheet.....and RESULTS 2 needs to pull in data from WEEK 2, not WEEK
1.......anyone know how to get this pasted over, or a different way so
I dont
have to manually type in the formula for all 17 sheets?

thanks
Kris

Hi Kris

Try Edit Replace WEEK 1 with WEEK 2 etc


--
Paul Sheppard


------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=467712