Worksheet Reference

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
 
H

Harlan Grove

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]
 
A

Admirer

Is it practical for you to eliminate the decimal portion of the sheet's
name? ("18.5" to "18")
 
Top