Questions in line below


Incredible!!! You are on the right track…
I will also reply here instead of the previous posts to keep it
current...


My initial thought was always around the device/module addresses, but
after giving this more thought, If it’s not too much to include, I think
it should also populate the zones, these have the device type value of
(3) and the loopselection of (0) they should be in the format of
Z000-Z999…The device type values of (5) can be excluded

Just to be clear
If Device Type = 3
Merged Address = Znnn where nnn is the Device Address with three digits
and
you also want to have blank entries for the missing values in the range of 000-999

(So it would not be L00Z000 - L00Z999 but just Z000-Z999)



Question…
Is there a way to have it look at the “summary” sheet to see if the Node
Address, LoopSelection, DeviceAddress and Merged Address fields need to
be updated…I know I told you this is manually populated but my thought
is that if an additional loop was added in the field panel not exceeding
ten loops, rather than having to manually insert the additional rows,
have the code do it?

As designed, the code I have provided generates a CompareData sheet (named CompareData2) using the sheet PanelData. I have not got to the Summary sheet yet.

Is the entire summary sheet manually generated?
If so, how do you mitigate for data entry errors?
If not, how is it generated.

Another concern I have is what if the technician re-labels a
device/module or zone, how can we update the summary sheet with the
revised labels.

What process does the technician go thru in order to do this.

Originally I planned to have code look at both sheets
labels

what do you mean by "both sheets labels"?

and if they were both greater than blank then overwrite the data
on the summary sheet in the same row/cells.

This specification needs clarification.

---------------------------------------


There is one piece that was too complicated for me, that may prove easy
for you…On the “PanelData”column “K” there is values that correlate to
another worksheet that is imported named “DeviceType”. On that Sheet
“DeviceType” in Column “A” it has those same values and in Column ”E”
has the Device Type Labels that if possible, I would like to included on
Both the “Summary” and “CompareData2” Worksheets Column “J” (once they
both match column wise)

I don't know what you are trying to specify here. Column K on PanelData is marked, on my copy, TypeID with a notation it is to be removed to reduce file size. There is no data there.
But any column from PanelData can be included on CompareData. 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 could not fill in the NodeAddress column as I do not know how these
are derived from the information I have.


Since the panel will max out with the (10) loop the node address will be
1 throughout the column..

I will modify the code to include the NodeAddress


This will be use on Excel 2007 and not on a Macintosh

BTW I was going to tell you that there was a small issue, if on another
tab when the macro is ran the results are not what is expected… But you
seemed to have fixed it on the revised code…


+-------------------------------------------------------------------+
+-------------------------------------------------------------------+