Forum Discussion
Cell reference auto populate
Not sure this is possible.
I want to define names of about 1800 cells. Then when I type a cell name in one cell, the refenced cell populates with the cell name where the original is populated. (ie I type B1 in cell A1. Cell B1 populates with A1)
Thanks for the help, much appreciated.
Your example doesn't quite make sense. Here's a useful reference to how named ranges work.
If that doesn't help you resolve it on your own, please come back with a more complete and clear description using names other than A1 and B1. Those are cell references, not names..... besides which, typing something into A1--whatever it is--isn't ipso facto going to make something appear in B1 unless there is a formula in B1 reading, simply, =A1. And if that's all you're looking for, this isn't a matter of naming cells; it's a matter of formulas.
OK, I'll give a better explanation.
I'm trying create a wiring guide where each cell is given a name based on its destination. I want to only type in one end of the guide, and have the other end populate.
I need the names of the cells in collumn A to be 1A-1 to 1A-300. Collumn B to be the same but replace A with B. This same pattern goes to collumn H.
Then, I would like to be able to type any destination in any cell and have the refenced destination populate with the cell of the original reference. For example, if cell A1 is named 1A-1, and I type in it 1B-1, then B1 (named 1B-1 now) auto populates with 1A-1. If I put 1C-33 in cell A2, cell C33 will populate with 1A-2.
Have you heard that somebody has done something like this with Excel? It may be possible, but it's certainly not a "standard" application for Excel. I'm just wondering if there's not a software package more suited to the task, perhaps some sort of CAD-CAM software that architects use.
I would assume, for example, that ultimately you're expecting a wiring diagram as the output, and that diagram would somehow make visible the connections you establish between Start and Destination cells.
In any event, let's go back to the "normal" references for cell names. Why not, instead of the sequence you're describing, where you type in the source cell the name of the destination cell and expect the former to appear in the latter, why not simply enter the source name in the destination cell? Doesn't that accomplish the same thing? You have both pieces of information at the start; use that information differently.
