Defind a Named Range based on a cell value

[Trachr]

My gut is saying this is impossible, but I figured I could ask since it will make my life easier if it can be achieved


Say I have a column B10-B20 and the user enters some value into some or all of these cells

Now is it possible to have a named range that the value would =B10 but also that the name itself of that item would also be dynamic so say someone enters "widget" into B10 the named range would be something like: =CONCATENATE(something,B10)

Like I said I doubt its feasible but would be really nice if it can be managed.



Thanks.

[Norie]

Any chance you could upload a sample workbook?

Click on GO ADVANCED and use the paperclip icon to open the upload window.

[Trachr]

Sure, Basically in this example I will have Columns B,C,E COlumns D and F are what I would like the named range to be for the cell to its left So If possible I would have C6 have a name of D6 and E7 having a name that is F7

I wont know the names people enter if need be I'll make the names be like APIIDuser1 or APICODEuser2 etc but I'm just trying to see if there is a way to get the contents of Columns B into the named range.

[Trachr]

well I have managed what I want to do after a fashion... I still have a few issues but this is what I've managed so far.

Please Login or Register  to view this content.

I still need to apply this to more than 1 cell, preferably a range of cells or even a full column