hello Nick, IT IS Amin. i like your Blog ;)

i'd like to know how can i build a report which can give me all the items which evoluated between 2 files.

example file 1

company Sales

ABC 200 Euros

bcd 100 euros

File 2

company Sales

ABC 250 euros

bcd 100 euros

here we see an evolution of 50 euros for company abc.

every time i get the latest file, i compare it with the file before. I use VLOOKUP function to determinate if there is a gap. what can you suggest me? arhardisse@hotmail.com

thanks