I'm trying to automate a wiring harness tool in Excel but not sure the best way to do it.
The wiring harness comprises of connectors and pins, below is a simple example
There are 2 connectors identified as C1001 and C1002 and each connector has 5 pins.
The table below shows the format of how the connectors and pins are assigned.
e.g.
- connector C1001 pin 1 goes to connector C1002 pin 2
and vice versa...
- connector C1002 pin 2 goes to connector C1001 pin 1
Below is a diagram of the tables above...
I would like to automate some of this process.
Starting with blank tables, imagine I enter the destination for connector C1001 pin 4 to be C1002 pin 3....
As soon as I have done that, I want the corresponding connector (C1002 pin 3) to detect this and be populated automatically...
What makes this more difficult is the fact I want any connector to perform this task.
For example, I might populate it vice versa and enter the destination for connector C1002 pin 3 to be C1001 pin 4....
As soon as I have done that, I want the corresponding connector (C1001 pin 4) to detect this and be populated automatically...
Ideally I would like it to happen in real time, but if not then an update button might be acceptable.
I'm just trying to think of a method on how to implement it, assuming its even possible ?
Whether its using lookup functions or some kind of database function or if necessary even some VBA
The wiring harness comprises of connectors and pins, below is a simple example
There are 2 connectors identified as C1001 and C1002 and each connector has 5 pins.
The table below shows the format of how the connectors and pins are assigned.
e.g.
- connector C1001 pin 1 goes to connector C1002 pin 2
and vice versa...
- connector C1002 pin 2 goes to connector C1001 pin 1
Below is a diagram of the tables above...
I would like to automate some of this process.
Starting with blank tables, imagine I enter the destination for connector C1001 pin 4 to be C1002 pin 3....
As soon as I have done that, I want the corresponding connector (C1002 pin 3) to detect this and be populated automatically...
What makes this more difficult is the fact I want any connector to perform this task.
For example, I might populate it vice versa and enter the destination for connector C1002 pin 3 to be C1001 pin 4....
As soon as I have done that, I want the corresponding connector (C1001 pin 4) to detect this and be populated automatically...
Ideally I would like it to happen in real time, but if not then an update button might be acceptable.
I'm just trying to think of a method on how to implement it, assuming its even possible ?
Whether its using lookup functions or some kind of database function or if necessary even some VBA
