View Single Post
 
Old 04-13-2016, 06:10 PM
Justcallmeeesa Justcallmeeesa is offline Windows 7 64bit Office 2013
Novice
 
Join Date: Apr 2016
Posts: 2
Justcallmeeesa is on a distinguished road
Default 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?
Reply With Quote