Showing changes in data?

[F17RUK]

I need your help with some code on how to build a macro or guidance on the best way to do this

I have a excel spreadsheet list of Tag numbers unique - which have a about 6 attributes (data) i.e description, operational/Void, etc

This list is being updated every day online. Attributes are being updated and tags are also been added and made void. I need it to show me where things have changed since the last run of the report

i export the report every two weeks and i need to show:

Tags which have been added (new) since last run
Tags which have been deleted (made void in list) since the last run

Tags which may have had an attribute updated with a value since last load,

* showing- Tag/Attribute changed/Old Value/new Value

I want something automated, so i can just take an export and then paste it into excel and it can show me the above

i have now attached what type of data/file type i will be dealing with

the file attached shows two tabs, week 1 data and week 2 data, and the 3rd tab is what i would like to see comparing the data in the first two tabs.

i will be dealing alot of information, so really need it to be automated

any ideas?

any help would be appreciated

thanks

[arlu1201]

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.