DeveloperBarn

Okay, I am not sure if this is already a built-in function in Excel, but I have not yet found it. What I need to do, is build a function, so one worksheet can reference another worksheets cell/range dynamically.

Basically, say I have a worksheet named Summary. In this worksheet, it summarizes a list of part numbers. So, in column A, it will list part numbers. These part numbers each have their own individual worksheet, which is named the same as the part number.

How do I create a function to reference the name of the other worksheet from the part number in the Summary tab.

For instance, if I want to reference the worksheet for part number 123456789, and cell B25, how would I build this function. The code in excel to reference such worksheet from another is:

You cannot create that dynamically, hence why I think I need a function. I would also like the ability to reference a range as well and not just a single cell.

__________________
"You'll never be as perfect as BLaaaaaaaaarche."

have a look at the INDIRECT function. something like this:
A1 being the field that contains the worksheet name
B3 being the cell that contains the value.

__________________
Quote of the Month:
Mistakes: It could be that the purpose of your life is only to serve as a warning to others.

Questions to Ponder:
Why do banks charge you a "non-sufficient funds fee" on money they already know you don't have?

iif([sarcasm]=true,iif([you have to ask]=true,"didn't work","ha ha ha"),"not sarcasm")
copyright © 2008 sbenj69

Sarchasm: The gulf between the author of sarcastic wit and the person who doesn't get it.

Yep, that with a combination of ADDRESS() worked perfectly.

Thanks, mehere.