Comparing Data based on number found

hi,

im trying to compare data between spreadsheets but cant get it right or find what im looking for

i have the 'master' data on sheet1 and on sheets2,3---9 i have the data i need to compare against the master

i need to look up the account number (Column E on master, D on other sheets) and when there is a match i need to compare the relating data for the account number. ie: amount, rate, date to see if both are the same.

if they are the same i would like to put a tick/yes or some equivilant in column F in the master (sheet1)

if there are any differences (rate, date, amount) i would like to copy both sets of data (sheet1/sheet2) to a sheet called "Rec" and display them side by side

also, if any account number appears on one sheet but not on the other i would like to include that on the "rec" sheet as well


i have attached sample1 as an example
and sample2 as how the final result should look



as always, any help or point the right direction is appreciated

thanks

hi All,

anyone got any ideas for this. ive been doing a lot of searching and can only find code that compares one number with another.

i need code that compares the number as well as everything the number represents (ie. date/amount etc).

any ideas?