I have a workbook 17 sheets, but only 2 are the focus of this request.
1) Netw-T3-MCP1: This sheet contains all Ethernet related details for all networked control system hardware, including:
A) What switch & port a device connects to
B) IP address
C) VLAN ID
D) EN2T (PLC's Ethernet card) asigned
E) PLC Node #
2) MCP3-Enet Sw Charts: This sheet is needed to build the Ethernet switch details charts for inclusion in the respective Ethernet switch drawing. the trick is having the charts filled with blanks for each port in any given switch that is not listed in the Netw-T3-MCP1 sheet. I can get the arry formulas to work for the 1st chart; however, only the first chart works. The details in the first chart work perfectly, but the successive charts only have the same info as the first chart rather than the actual switches details. I cannot seem to figure out how to edit the formula to stop this. I am indexing the switch numbers to match.
13 freelancere byder i gennemsnit $365 på dette job
Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards. Stay tuned, I'm is still working on this proposal.