On Wed, 6 Mar 2013 00:40:35 +0000, TimLeonard wrote:



What we will need to decide is what changes in the Summary sheet we want
to retain. It may be that a list of valid changes/additions/deletions
will need to be provided to someone, who can make the changes in the
Panel.
I think any row that has a value in the "Project Number" column should
be retained. Since this repersents the Engineered Adds and Deletes
waiting to be programmed in the field. Also if a device is deleted
(wiped out) on the summary sheet the Device Type does not
clear...(Correction, if you delete one line at a time is works fine but
not with multiple lines)

Fixed and will be in the next set of macros I send you.



Also I sure your aware but if the create summary sheet macro is ran
twice it overwrites any manual entered devices. Perhaps this is because
we have not retained anything yet

Correct -- That part has not been coded yet.



It then formats the output so as to enable relatively easy analysis.
I'm sure there are better ways to format the output, and am open to any
suggestions that you think might make analysis of the data more clear.
This works I just need to play with it more, but for some reason deletes
the contents of the CompareData sheet after executing...

I cannot reproduce that phenomenon.
There should be no reason for the contents of CompareData to be deleted after running CompareDataVsSummary
CompareData contents gets deleted prior to its being created (and it gets recreated whenever we create the Summary sheet), but it should not be being cleared at other times.
Please post (or email) a copy of a misbehaving workbook so I may look at it more closely. I may need the exact steps you took to cause the contents of CompareData to be cleared.

Also would it be possible to order these as "Added Devices" "Deleted
Devices" and then "Changed Devices" there will be more adds and deletes
then changes...

Done


What I'd like to do is a single dialog box where the node is selected
(perhaps with a spinner) and then multiple loops would be allowed to be
chosen at the same time (check boxes with multiple selections allowed).
I think the engineers will be open to anything for this...

A preliminary version, which only presents the Dialog box, is with the last set of macros I provided. Let me know what you think.