Thread: compare data
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gingit Gingit is offline
external usenet poster
 
Posts: 21
Default 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,