#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
Maybe like the attached.
|
#3
|
|||
|
|||
Thank you!
I will give this a try!
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Pulling Data From Excel | ptmuldoon | Word VBA | 7 | 03-19-2016 03:28 PM |
Charts - formatting dates in a data table - Excel 2013 | IanGUK1 | Excel | 0 | 12-04-2014 01:44 AM |
Need help in automating data from multiple sheets into a single sheet | veedee | Excel | 1 | 06-11-2014 04:01 AM |
How do I merge data from one sheet in a workbook out into multiple sheets | nolesca | Excel | 4 | 06-07-2010 08:13 AM |
Mail merging and pulling varying data from Excel | shannag1881 | Mail Merge | 0 | 10-05-2009 08:51 AM |