Using tab names in formulae

S

Sara

I'm using Excel in Office 2011 running on Snow Leopard.

I have a workbook with about 100 pages in, each page has the tab name
set manually depending on the content. In one cell in each page I want
to generate a number based on that cell in the page immediately to the
left.

At the moment I'm using a simple formula:

D3=tabName!D3+1

with me entering tabName manually.

This works until I insert an extra page somewhere and forget to amend
the formula on the next page. What I would like to have is something
like:

D3=NameOfPageImmediatelyToTheLeft!D3+1

with NameOfPageImmediatelyToTheLeft being autmatically filled in.

Any ideas anyone?
 

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

Similar Threads

Grouping Names in Mail Merge 0
Indenting every other paragraph in Word at the same time? 0
Changing case using the PROPER formula 2
Word Template where user inputs <TITLE> and then that can be displayed in footers or headers [MAC] 0
Office apps in chrome, toolbars are super tiny 0
Drop down list control value in vba 2
Tab Control 2
Using Styles In An Outline 0

Top