Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #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
 



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 07:26 AM.


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