Hi All,

I have 5 users working on a macro. All of them are using different
workbooks from there desktops but the macro is same.

At the end of the when the work is done all of them transfer their
data to a workbook(well I call it datadump) which is located in shared
drive. Some times when the users transfers the data to the datadump
workbook duplicate entries are created.

For an example: User one has done ten case studies in a day, at the
end of the day before leaving he will transfer the data to the
datadump workbook which is on shared drive and on the other day when i
generate the report I see 20 case studies. It has happned very few
times but I am not able to understand the cause.

I dont know what is going wrong. Please help....

Regards
Heera Chavan