Sheet Reference in Formula

J

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
 
Y

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top