Excel 2013 Pulling data from 1 table to multiple sheets
I've exported a list from SharePoint to an excel 2013 worksheet that I refresh weekly for a report. The table contains a large amount of data with many columns with one of the columns (Action Status) containing 3 possible statuses. 1 pending, 2 complete, 3 not required. I would like to have 3 tabs (sheets) that pull just those actions and its related information to each of those tabs. All pending items on 1, 2 complete etc... i need these sheets to update when I refresh the first worksheet. What is the most effective way to do this?
|