Hi,

Everyday we will get lot of files to work on them which is having a quote number to identify the files.

We will distribute these files to our team which are of 40 people ,each can do 25 files a day.

We are having main sheet with all of teh quote numbers we got today, so at the end of he day will go to each member and manually the files they done and we will update in the main sheet as 'done' in one column and respective person name in another column.

As it is consuming 2 hours aday to do this, But I need to do this using Excel macros.

Please let me know if required more info and help us, Thanks in advance.

Regards
Sarath