+ Reply to Thread
Results 1 to 2 of 2

Large Data Summary that I want to split out to tabs per a column entry - auto updating

  1. #1
    Forum Contributor
    Join Date
    07-16-2014
    Location
    Yorkshire
    MS-Off Ver
    MS 10
    Posts
    100

    Large Data Summary that I want to split out to tabs per a column entry - auto updating

    Hi all,

    I have a spreadsheet with a large summary sheet that shows information about individuals, this has at the far right end a number of columns that show departments (each department has its own column) in which they will work in the future.

    What I would like is to be able to split the summary into the individual departments on their own tabs, but I would like these to remain live, so any update to the summary page will be reflected in the individual department listings.

    Hope this makes sense and would welcome any potential solutions.

    Thanks
    seash

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,984

    Re: Large Data Summary that I want to split out to tabs per a column entry - auto updating

    You need to post a sample sheet, as we cannot possibly guess how your data are laid out. Since different Excel evesions do different things, and where you are in the world determines the regional settings that apply - it would be helpful to know what version of Excel you want this to work for and whaich region of the world you're in. That's why they're asked for in your profile...




    Please attach a sample workbook. Make sure there is enough data to demonstrate your need. Make sure your desired results are shown, mock them up manually if necessary. Remember to remove ALL confidential information first!!!

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    The paperclip icon
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Creating auto updating Summary Sheet
    By baldymon in forum Excel General
    Replies: 3
    Last Post: 08-06-2014, 02:55 AM
  2. Macro to split Large Worksheet Into Multiple Tabs
    By asmith08 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-02-2014, 06:45 PM
  3. [SOLVED] NEw tabs, auto updating summary tab
    By Mechanical Pencil in forum Excel General
    Replies: 3
    Last Post: 11-11-2013, 09:57 AM
  4. Replies: 4
    Last Post: 05-02-2013, 04:39 PM
  5. [SOLVED] Large amt of data needing to be split onto diff tabs
    By Arliene in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 07-18-2012, 10:00 AM
  6. [SOLVED] Split data in to multiple tabs using value in column
    By Manpar in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-09-2012, 08:33 AM
  7. Macro for creating tabs linked to auto summary
    By dscape in forum Excel General
    Replies: 0
    Last Post: 05-21-2009, 06:33 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1