Hi,

Is it possible that I can write a formula that uses the name of a cell in the present sheet to reference another sheet (in the same workbook) with that name?

I've kind of got it to work, but it wasn't as simple as I was hoping. Here's an example of what I want to do.

In column A I have the months listed, January to December. I also have 12 other worksheets, named January to December.

Let's say I want to reference cell B10 in the January sheet. I could write =January!B10, and that would work fine.

In the present worksheet, the word January is in cell A14. So if I type the formula instead as =A14!B10 it opens up a box called "Update Values: A14", and it requires me to specify the workbook and worksheet that I'd like to reference. The problem is, this is hardly time saving, and I want to be able to copy the formula to multiple other cells, so I don't think this method is practical.

Is there a solution to this? I'm using Excel 2007 by the way.

Many thanks for your help.