Worksheet Reference

  • Thread starter Thread starter Burt
  • Start date Start date
B

Burt

is there a forumla or function i can use to make reference
to a previous worksheet

e.g. sheet 19 has a formula that relates to sheet 18. but
i insert a sheet 18.5 then the formula updates to refer to
this one instead

tia
 
Burt said:
is there a forumla or function i can use to make reference
to a previous worksheet

e.g. sheet 19 has a formula that relates to sheet 18. but
i insert a sheet 18.5 then the formula updates to refer to
this one instead
Click to expand...

You either need to use VBA or an ordered list of worksheet names to do this.
Microsoft apparently hasn't been able (or far more likely doesn't want to be
bothered to expend the resources necessary) to add any functionality to
allow for 'relative' worksheet referencing.

See the following linked article for work-arounds.

http://google.com/[email protected]
 
Is it practical for you to eliminate the decimal portion of the sheet's
name? ("18.5" to "18")
 
Back
Top