Hello

I would like to know whether it is possible to do something with the use of
a macro.

Could a macro be recorded (or written) that compares the data from a single
worksheet in one spreadsheet with the data in two worksheets on another
spreadsheet?

EXAMPLE
Let's assume all worksheets have the same column headings. One of these is
an End Date field, and another of these is a User ID field. What I want is
to compare the data in the first main spreadsheet with that in the second
spreadsheet so that if a row of data has the same User ID and if the End
Date recorded in the main spreadsheet is later than that recorded in one of
the other two worksheets on the second spreadsheet, then that data is copied
across to the second spreadsheet.

Basically, it takes us about three hours every week to go through and do
this manually, and I am thinking there has got to be a better way.

Any advice or suggestions would be most appreciated.

Thanks,

Joe.