Hi
Sorry if this seems misleading but i will try to make it straight
forward. I run a data warehourse serch using Discover 4i every day. The
search is identical but looks for additional data added to and area on a
daily basis. Eg A1 show 3 on Mon A15 (this is the same data to comapre
but the export from discovery copied below yesterday results) shows 7 on
Tue this is done over an array of cells.
I export the results from Discover 4i into Excel ithen run it the day
after and export into the same worksheet. I want Excel to look at todays
data and comapre it with yesterdays data and and say in F1 it shows a
result of +4 the difference between A1 yesterday and today A15