Worksheet Reference

[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

 

[Harlan Grove]

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

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]

 

[Admirer]

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