Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Excel 2013 Pulling data from 1 table to multiple sheets Excel 2013 Pulling data from 1 table to multiple sheets
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
Old 04-13-2016, 06:10 PM
Justcallmeeesa Justcallmeeesa is offline Excel 2013 Pulling data from 1 table to multiple sheets Windows 7 64bit Excel 2013 Pulling data from 1 table to multiple sheets Office 2013
Novice
Excel 2013 Pulling data from 1 table to multiple sheets 		 
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
  #2  
Old 04-13-2016, 09:38 PM
xor xor is offline Excel 2013 Pulling data from 1 table to multiple sheets Windows 10 Excel 2013 Pulling data from 1 table to multiple sheets Office 2016
Expert
  
Join Date: Oct 2015
Posts: 1,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default
Maybe like the attached.
Attached Files
File Type: xlsx Pendig_Complete.xlsx (13.0 KB, 12 views)
Reply With Quote
  #3  
Old 04-14-2016, 09:15 AM
Justcallmeeesa Justcallmeeesa is offline Excel 2013 Pulling data from 1 table to multiple sheets Windows 7 64bit Excel 2013 Pulling data from 1 table to multiple sheets Office 2013
Novice
Excel 2013 Pulling data from 1 table to multiple sheets 		 
Join Date: Apr 2016
Posts: 2
Justcallmeeesa is on a distinguished road
Default Thank you!
I will give this a try!
Reply With Quote
Reply

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2013 Pulling data from 1 table to multiple sheets 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
Excel 2013 Pulling data from 1 table to multiple sheets Need help in automating data from multiple sheets into a single sheet veedee Excel 1 06-11-2014 04:01 AM
Excel 2013 Pulling data from 1 table to multiple sheets 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

Other Forums: Access Forums

All times are GMT -7. The time now is 05:12 AM.

Contact Us - Privacy Statement - Top

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft