Sheet Reference in Formula

[JB Bates]

Hi

I WILL have 100 worksheets in my workbook. they are labeled Trip(1),
Trip(2), etc.
I need to be able to make a copy of Trip(2) which will be called Triup(3)
(and so on). I am successful at having it auto name my worksheets - but i
have a formula in the sheet which is ='TRIP(1)'!E39:F39

When I copy the sheet it is not updating the sheet reference. so when I
copy trip(2) to Trip(3) i want the formula to copy and update to read
='TRIP(2)'!E39:F39

Any Suggestions? thanks

 

[YESHWANT]

Hi JB Bates
try this one

copy trip(2) to Trip(3)
and click on edit - replace
"'TRIP(1)'!" with
"'TRIP(2)'!"

learn - n - enjoy