Display changes made in database

R

Robinazer

New Member
Joined
Feb 18, 2021
Messages
6
Office Version
  1. 365
Platform
  1. Windows
Since the last time I posed a question it made a task numerous hours shorter, I'm here again with another question.

At our company, everyone is able to change the records in our database. To our annoyance, this means they often change things they shouldn't. Since changes that do need to happen also happen often, we can't just reverse the database to an older version when they do end up changing stuff.

Is there a way to check the 2 database files and display every item that was changed, removed or added and its 2 different versions?

The fixed values of each row are "ontvanger", "kostenplaats" and "locatie - niveau 1".

The file needs to display the 2 versions of data after changes in the following data:

  • "Artikel"
  • "Artikelomschrijving"
  • "Maximale hoeveelheid"
  • "Reservehoevh. Eenheid"
  • "locatie - niveau 2"
  • "locatie - niveau 3"
  • "locatie - niveau 4"
If a certain article number ("Artikel") gets removed out of a location or when a new one gets placed there, this needs to be displayed as well.

In the mini sheet, you'll find a file with 2 versions of our database with the item description deleted for obvious reasons.
database Example.xlsx
ABCDEFGHIJKL
3100APOTH KASTEN830021115STU1453AANKEKON
3101APOTH KASTEN83005152100STU1441AANKEKON
3102APOTH KASTEN83005180100STU1443AANKEKON
3103APOTH KASTEN83005237100STU1314AANKEKON
3104APOTH KASTEN83005240120STU1321AANKEKON
3105APOTH KASTEN83005243200STU1312AANKEKON
3106APOTH KASTEN83005245120STU1323AANKEKON
3107APOTH KASTEN8300529712BUS1251AANKEKON
3108APOTH KASTEN83005485180STU1211AANKEKON
3109APOTH KASTEN83005499100STU1311AANKEKON
3110APOTH KASTEN83005767125STU1313AANKEKON
3111APOTH KASTEN8300581160STU1322AANKEKON
3112APOTH KASTEN8300581560STU1331AANKEKON
3113APOTH KASTEN830011026100STU1233AANKEKON
3114APOTH KASTEN8300112922DOO1333AANKEKON
3115APOTH KASTEN8300112932DOO1332AANKEKON
3116APOTH KASTEN83001719320STU1234AANKEKON
3117APOTH KASTEN830017950300STU1342AANKEKON
3118APOTH KASTEN830017951100STU1343AANKEKON
3119APOTH KASTEN830017952300STU1341AANKEKON
3120APOTH KASTEN83001816518STU1221AANKEKON
3121APOTH KASTEN8300182341STU1451AANKEKON
3122APOTH KASTEN8300236355DOO1442AANKEKON
3123APOTH KASTEN83002461325STU1452AANKEKON
3124APOTH KASTEN830030019120STU1232AANKEKON
3125APOTH KASTEN8300314321000STU1212AANKEKON
3126APOTH KASTEN8300337651000STU1111AANKEKON
3127APOTH KASTEN83003549640STU1352AANKEKON
3128APOTH KASTEN830035497100STU1351AANKEKON
3129APOTH KASTEN8300362712ROL1122AANKEKON
3130APOTH KASTEN8300362721ROL1123AANKEKON
3131APOTH KASTEN8300362732PAK1121AANKEKON
3132APOTHEEK8300101010STU20028AANKEKON
3133APOTHEEK830010661STU20040AANKEKON
3134APOTHEEK8300141421STU20038AANKEKON
3135APOTHEEK8300142410STU20039AANKEKON
3136APOTHEEK830014401ROL20071AANKEKON
3137APOTHEEK830014501STU20019AANKEKON
3138APOTHEEK830014511STU20020AANKEKON
3141APOTHEEK8300146312ROL20023AANKEKON
3142APOTHEEK830014642PAK20025AANKEKON
3144APOTHEEK8300148110PAK20033AANKEKON
3145APOTHEEK830014961ROL20017AANKEKON
3146APOTHEEK830015031STU20042AANKEKON
3147APOTHEEK830015051STU20043AANKEKON
3148APOTHEEK830015061STU20044AANKEKON
3149APOTHEEK830015101STU20045AANKEKON
3150APOTHEEK830015115STU20047AANKEKON
3151APOTHEEK830015155STU20049AANKEKON
3152APOTHEEK830015165STU20050AANKEKON
3153APOTHEEK830015221PAK20029AANKEKON
3154APOTHEEK830015265STU20046AANKEKON
3155APOTHEEK830015285STU20048AANKEKON
3156APOTHEEK8300153810PAK20032AANKEKON
3157APOTHEEK830015412SET20037AANKEKON
3158APOTHEEK8300154525STU2003AANKEKON
3160APOTHEEK830016861DOO20027AANKEKON
3164APOTHEEK830018371STU20024AANKEKON
3165APOTHEEK830018381STU20031AANKEKON
3166APOTHEEK830018551STU2005AANKEKON
3167APOTHEEK8300191660STU20026AANKEKON
3168APOTHEEK830019221DOO20036AANKEKON
3169APOTHEEK8300195120STU20064AANKEKON
3172APOTHEEK830022281STU20018AANKEKON
3173APOTHEEK83002243100STU2007AANKEKON
3174APOTHEEK830022825PAK20067AANKEKON
3175APOTHEEK8300233610STU20013AANKEKON
3176APOTHEEK830038855DOO20072AANKEKON
3178APOTHEEK83005310100STU2001AANKEKON
3179APOTHEEK83006069100PAA1411AANKEKON
3180APOTHEEK8300607150PAA1412AANKEKON
3181APOTHEEK83007695100STU20063AANKEKON
3182APOTHEEK830082831DOO20069AANKEKON
3183APOTHEEK8300110432STU20052AANKEKON
3184APOTHEEK83001636940STU20062AANKEKON
3185APOTHEEK830016548500STU20022AANKEKON
3186APOTHEEK83001672910STU2004AANKEKON
3187APOTHEEK8300171721STU20051AANKEKON
3190APOTHEEK8300215771PAK20066AANKEKON
3192APOTHEEK8300222961DOO20070AANKEKON
3193APOTHEEK83002482520STU20015AANKEKON
3194APOTHEEK8300250752100STU20014AANKEKON
3195APOTHEEK8300263592DOO20010AANKEKON
3196APOTHEEK8300275861PAK20068AANKEKON
3197APOTHEEK830027592300STU20012AANKEKON
3198APOTHEEK83002764325STU20065AANKEKON
3199APOTHEEK8300292131STU2002AANKEKON
Database New


database Example.xlsx
ABCDEFGHIJKL
3100APOTH KASTEN830021115STU1453AANKEKON
3101APOTH KASTEN83005152100STU1441AANKEKON
3102APOTH KASTEN83005180100STU1443AANKEKON
3103APOTH KASTEN83005237100STU1314AANKEKON
3104APOTH KASTEN83005240120STU1321AANKEKON
3105APOTH KASTEN83005243200STU1312AANKEKON
3106APOTH KASTEN83005245120STU1323AANKEKON
3107APOTH KASTEN8300529712BUS1251AANKEKON
3108APOTH KASTEN83005485180STU1211AANKEKON
3109APOTH KASTEN83005499100STU1311AANKEKON
3110APOTH KASTEN83005767125STU1313AANKEKON
3111APOTH KASTEN8300581160STU1322AANKEKON
3112APOTH KASTEN8300581560STU1331AANKEKON
3113APOTH KASTEN830011026100STU1233AANKEKON
3114APOTH KASTEN8300112922DOO1333AANKEKON
3115APOTH KASTEN8300112932DOO1332AANKEKON
3116APOTH KASTEN83001719320STU1234AANKEKON
3117APOTH KASTEN830017950300STU1342AANKEKON
3118APOTH KASTEN830017951100STU1343AANKEKON
3119APOTH KASTEN830017952300STU1341AANKEKON
3120APOTH KASTEN83001816518STU1221AANKEKON
3121APOTH KASTEN8300182341STU1451AANKEKON
3122APOTH KASTEN8300236355DOO1442AANKEKON
3123APOTH KASTEN83002461325STU1452AANKEKON
3124APOTH KASTEN830030019120STU1232AANKEKON
3125APOTH KASTEN8300314321000STU1212AANKEKON
3126APOTH KASTEN8300337651000STU1111AANKEKON
3127APOTH KASTEN83003549640STU1352AANKEKON
3128APOTH KASTEN830035497100STU1351AANKEKON
3129APOTH KASTEN8300362712ROL1122AANKEKON
3130APOTH KASTEN8300362721ROL1123AANKEKON
3131APOTH KASTEN8300362732PAK1121AANKEKON
3132APOTHEEK8300101010STU20028AANKEKON
3133APOTHEEK830010661STU20040AANKEKON
3134APOTHEEK8300141421STU20038AANKEKON
3135APOTHEEK8300142410STU20039AANKEKON
3136APOTHEEK830014401ROL20071AANKEKON
3137APOTHEEK830014501STU20019AANKEKON
3138APOTHEEK830014511STU20020AANKEKON
3141APOTHEEK8300146312ROL20023AANKEKON
3142APOTHEEK830014642PAK20025AANKEKON
3144APOTHEEK8300148110PAK20033AANKEKON
3145APOTHEEK830014961ROL20017AANKEKON
3146APOTHEEK830015031STU20042AANKEKON
3147APOTHEEK830015051STU20043AANKEKON
3148APOTHEEK830015061STU20044AANKEKON
3149APOTHEEK830015101STU20045AANKEKON
3150APOTHEEK830015115STU20047AANKEKON
3151APOTHEEK830015155STU20049AANKEKON
3152APOTHEEK830015165STU20050AANKEKON
3153APOTHEEK830015221PAK20029AANKEKON
3154APOTHEEK830015265STU20046AANKEKON
3155APOTHEEK830015285STU20048AANKEKON
3156APOTHEEK8300153810PAK20032AANKEKON
3157APOTHEEK830015412SET20037AANKEKON
3158APOTHEEK8300154525STU2003AANKEKON
3160APOTHEEK830016861DOO20027AANKEKON
3164APOTHEEK830018371STU20024AANKEKON
3165APOTHEEK830018381STU20031AANKEKON
3166APOTHEEK830018551STU2005AANKEKON
3167APOTHEEK8300191660STU20026AANKEKON
3168APOTHEEK830019221DOO20036AANKEKON
3169APOTHEEK8300195120STU20064AANKEKON
3172APOTHEEK830022281STU20018AANKEKON
3173APOTHEEK83002243100STU2007AANKEKON
3174APOTHEEK830022825PAK20067AANKEKON
3175APOTHEEK8300233610STU20013AANKEKON
3176APOTHEEK830038855DOO20072AANKEKON
3178APOTHEEK83005310100STU2001AANKEKON
3179APOTHEEK83006069100PAA1411AANKEKON
3180APOTHEEK8300607150PAA1412AANKEKON
3181APOTHEEK83007695100STU20063AANKEKON
3182APOTHEEK830082831DOO20069AANKEKON
3183APOTHEEK8300110432STU20052AANKEKON
3184APOTHEEK83001636940STU20062AANKEKON
3185APOTHEEK830016548500STU20022AANKEKON
3186APOTHEEK83001672910STU2004AANKEKON
3187APOTHEEK8300171721STU20051AANKEKON
3190APOTHEEK8300215771PAK20066AANKEKON
3192APOTHEEK8300222961DOO20070AANKEKON
3193APOTHEEK83002482520STU20015AANKEKON
3194APOTHEEK8300250752100STU20014AANKEKON
3195APOTHEEK8300263592DOO20010AANKEKON
3196APOTHEEK8300275861PAK20068AANKEKON
3197APOTHEEK830027592300STU20012AANKEKON
3198APOTHEEK83002764325STU20065AANKEKON
3199APOTHEEK8300292131STU2002AANKEKON
Database Old


In the entire database, some rows have been changed, some have been deleted and some have been added. All this needs to be displayed properly. Is there anyone who knows the best way to do this? Many thanks in advance as this would make my work a whole lot faster and pleasant.
 

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.
You must log in or register to reply here.

Similar threads

G
  • Question Question
Links to cells in other Workbooks occasionally change the WORKSHEET reference. Why?
2
Replies
11
Views
1K
GTS
G
D
  • Solved
Cannot COUNT/SUM Displayed Table Values, Table Filtered Values Out of Order
Replies
3
Views
374
Alex Blakenburg
A
E
  • Question Question
Search function not finding rows containing the matching value
Replies
1
Views
668
GlennUK
G
D
  • Question Question
Trouble with Excel cutting off Data in a CSV file
Replies
2
Views
828
Bosquedeguate
Bosquedeguate
D
  • Solved
Cdbl textBox showing as Text Error in Worksheet
Replies
4
Views
822
RoryA
RoryA

Forum statistics

Threads
1,223,886
Messages
6,175,196
Members
452,616
Latest member
intern444

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top