Master sheet populating data to other sheets

Lucaso - May 23, 2018 at 02:52 PM

I'm trying to create a workbook with a master sheet and four subsequent sheets. Ideally the master sheet will be where my admin assistant will enter various assignments and tracking items. There are various categories and ways of recording the items so they fall under a single table. They each have their own table for tracking in the master sheet. The master sheet, through a macro or command button, would then identify who the item is assigned to and populate the information in the right location in the corresponding sheet.

The person viewing the workbook could then simply look at their sheet and scroll through the categories for what they are responsible for, due dates, and progress.