i have a master list having 10000 members.
members who should be in category "A" are in the second worksheet, those in
category "B" are in the third worksheet. for several categoires.

i have introduced a categories clounm in the master list and i need to fill
in the categories based on wether a member appears in the second third or
fourth worksheet.

the member numbers are similar in tha master list and in the categories
work sheets.

is there a quick way of filling in the categories column.

thanks