Correct… Just Z000-Z999
Understood…
Yes at this point it is manually generated and there is no error check,
But since the "PanelData" is what is programmed in the field panel and the “Summary” sheet is manually imputed, I am sure there will be times when the two worksheets will differ concerning the same rows/cells….Now here is where it gets tricky to explain…The “Summary” sheet in theory, should have all the programmed rows/cells populated the same as the “CompareData” sheet Plus it should also have the additional device address information that have been used on all the drawings not yet installed and programmed into the field panels.
So I believe if it was to have something coded to verify if a loop was added or if label changes have been made in the field and then update the summary sheet with the changes it should only look at rows/cells that were populated on both worksheets and should not change / update any rows/cells that are only on the “Summary” Sheet that relate to the engineered devices that have not been installed or programmed in the field panel and does not match the “PanelData” sheet….

The technician programs the control panel out in the field (building) he then downloads the panel and it comes back to the office as an .mdb file. I then import that file as the “PanelData” worksheet. The concern is if changes come from the field I think we need a way to update or overwrite the manually imputed Summary sheet to keep it current… FYI the PanelData device labeling and zone labeling will always take precedence since it is what is programmed in the field, For example, the engineer may call a label “corridor 1650” but the technician may be required to program it “North Corridor 1650” and that will be what matters so the question was, how to update the “Summary sheet to reflect the what was actually programmed in the field panel…

In regards to the comment…[ Originally I planned to have code look at both sheets labels “if they were both greater than blank then overwrite the data on the summary sheet in the same row/cells.” ]
I was referring to the “DeviceLabels” and the “Extended Labels” columns of to both sheets, the “Summary” and the “CompareData” worksheets…This would have been the only way I would have known to do it….I am sure there are better ways to update the labels so I am opening the door to suggestions


I will attached another workbook that has all the “PanelData” columns populated and has the “DeviceType” worksheet…..
You said the following: “You just enlarge the vPD array to accomodate it. If you are adding data from other worksheets, you are going to need to be sure it matches up with the devices/zones that are already there.” …..I think it might be a little more complicated, “PanelData” Column K refers to a number the matches a number in the worksheet “DeviceType” column A and the label in column “E”..
To illustrate, sheet “PanelData” row 1020 column “K” has a value of 40, sheet “DeviceType” column “A” row 7 has the same value of 40 and column “E” has the label of “Smoke(Photo)”…This is what I would like to put on the sheet “CompareData2” row 1020 column “J”

Sorry but I revised the statement and I don’t think you caught that…
Since the panel will max out with the (10) loop for the NodeAddress, it will be "1" for the first (10) loops then it will be "2" for the next (10) loops and so up to 104 NodeAddresses. However most "PanelData" sheets will only contain 1 NodeAddress