Forum Discussion
Cell reference auto populate
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.
- I hanks again for the input!
Your assumption is correct that the ultimate goal is a wiring diagram. I would be using this info in conjunction with CAD software. I would copy the text from excel to Autocad. Currently my company does not have the best software for wiring and I don't expect it in the near future , so this was a solution I was exploring.
The diagram I am creating needs to show both the source and destination and their connections so while your solution makes sense (and would make my life easier) it doesn't meet the requirement of the product I need to develop. In the end, there are roughly 900 connections being made, meaning 1800 lines of text on the drawing. The goal with my idea was efficiency and accuracy. I would only need to type out one line of text to get the full connection.
I have not heard of anyone being able to accomplish this but thought I would ask the Microsoft community.
