Hi all,

I have Sheet1 having collective data. Having information for individual
Directors scattered on the spreadsheet mainly in Test format..... i.e
response to particular action or progress report....

Using code I filtered and copied data along with format to individual
Directors named sheet. So that when they click sheet of their name they
can see only their respective data........

Now I want :

When they edit their data on their respective sheet shld update on the
Main sheet at the same original location.

PLS TAKE CARE DATA IS SCATTERED ON THE SHEET ALL OVER...
Its not grouped & shld not be grouped on Sheet1(main) sheet.

Looking fwd to hear earliest ....

Trying hard since 2 days........
need urgently for my job.......

Thanks
neelam



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/