Hello All,

I have a workbook where i have around 9 worksheet. I have patient details on
worksheet name "ALL". I have a dropdown menue in main worksheet "ALL". There
are 8 items in the drop down menu. I have created 8 worksheet with same name
as items in dropdown menue.

My requiremnet is to copy and paste the specific Data coulmn to the another
worksheet for which dropdown item is slected.

Say i have List in dropdown menu as A, B, C,D,E,F. I have also created
worksheet as A, B,C,D,E,F. If a user select A from the dropdown menue the
entire Data couln should be copied into worksheet A and same for all other
menue item.

How can i do it ?

Thanking You

Regards

Niraj