Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sheet Reference in Formula
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reference a Sheet in Formula | Excel Worksheet Functions | |||
Formula in a sheet reference | Excel Worksheet Functions | |||
Use cell value as reference to sheet in formula? | Excel Worksheet Functions | |||
Formula to reference name of sheet tab | Excel Discussion (Misc queries) | |||
Need formula for sheet & cell reference | Excel Worksheet Functions |