I have a requirement like i have the data in spread sheet which i download from the website(on any day) and manually i have to add the filed " download date".
So the data fields are like download date,sr no,logged date, entry#, total amout etcc...
The requirement is the data which we have to download from the website is change at any time.Here we have to compare the data between the first time downloaded spread sheet and next time downloaded spread sheet as a weekly basis.
Eg: download date sr no logged date entry# total amount
04/07/13 101 28/06/13 100098 600000 total records we have is 1001
2nd downloaded spread sheet
download date sr no
logged date
entry#
total amount
01/07/13
101
28/06/13
100098
600000
total records we have is 1020
Note : the thing is columns are same in both the times but only rows will change.We have to compare the changes week by week.
Let me know if in case of any concerns in this regard.