ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   compare data (https://www.excelbanter.com/excel-discussion-misc-queries/143323-compare-data.html)

Gingit

compare data
 
I have the following spreadsheet in two tabs:

in Tab1:
Data a b c d
Data1 52 963
Data2 547 58 665
Data3 221 454 658
Data4 58 100 954
Data5 50 45
Data6 416 250
Data7 88 558 22

In Tab2:
Data a b c d
Data1 52
Data4 58
Data6 416

With new data coming in weekly, how can I compare the two tabs based on Data
and see if a new amount appear in columns a-d (in tab1) to add the "Data" to
tab2?

Thanks,




All times are GMT +1. The time now is 12:09 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com