Hello,
I have a master excel sheet (One workbook) which is updated once in a
month from another sheet called datasheet (Another workbook) . Both
sheets (master and the datasheet) contain the same data. New
additions/updates/changes are added on a regular basis to the datasheet
and is then added to the master sheet at the end of the month.

The sheets consists of about 10 column headings with around 500 rows.
Now, when the datasheet is to be updated to the master sheet, I want a
macro which should find out if the data is already there (eg. it can
check this from employee code etc in the first column). If it is
already there in the master sheet, it should check whether all the
values/text associated with it are the same. If there are some changes
in the value of the cell/change in text, then the new value/text from
the other sheet should be updated to the master excel sheet.
Also, if there are new names/employee codes added to the datasheet,
then this should be updated on the master sheet on a new row.

I would be very grateful if anyone can throw some light on how to go
about this by using macro.

Thanks a ton.


--
lalthan
------------------------------------------------------------------------
lalthan's Profile: http://www.excelforum.com/member.php...o&userid=10557
View this thread: http://www.excelforum.com/showthread...hreadid=397222