I have a master list on one worksheet with 8 columns of data. One of
these columns (the 4th one) has a name entry. (there are only 4 names
that would be used in all)
I would like to have a macro or an excel formula to derive on separate
worksheets ( which means 4 additional sheet, named for each of the 4
named entries in masterlist, as an entry is being made on the
masterlist.
the end result would be so that I can sort be each name on a separate
worksheet.
I dont wish to use filters on the masterlist, something which I could
have used otherwise.
Any advice ?? thanks in advance. Sorab