I have a "master table" (worksheet called "MASTER TABLE") that records purchases made by three people (column B): P-A, P-B and P-C (selected from a drop-down list)
Each purchase is placed within one of 8 categories (column C), selected from a drop-down list
I want to have a separate worksheet for each category.
When an entry is made on the "MASTER TABLE" worksheet the information for THAT purchase is automatically added to the next row in the corresponding category worksheet.
I can do this manually by filtering the MASTER TABLE for each category, and then copy-paste the filter results into the appropriate category worksheet - this is what I have done in the attached sample file.
Is it possible to get this result automatically as a new purchase is entered.
Thank you very much for any help.
Bookmarks