+ Reply to Thread
Results 1 to 4 of 4

Is it possible to have a connected summary sheet to brake down sheets

  1. #1
    Registered User
    Join Date
    11-18-2016
    Location
    ESSEX
    MS-Off Ver
    2010
    Posts
    10

    Is it possible to have a connected summary sheet to brake down sheets

    Bit of background, Ive started a new job with my local council, within 2 weeks Ive become the unofficial IT guy and have remade the workbook we are using to do account reviews for the next few months ( the original they had was a complete mess)
    What I really want to do is be able to link my 1 sheet entry's to the other sheets which is going to cut the work load down by weeks.
    Im hoping someone can help me out or just tell me its not possible and ill leave it at that.


    So let me explain.
    I have a work book of 5 sheets, each sheet is laid out the same with the same columns.
    each row is an entry for an account, in total looking at about 15000 rows of entries.

    I have 1 complete list sheet with all the entries - those process the returned information will be working off this complete list ( team 2)

    I have 4 other sheets which brakes this complete list down based on the contact info we have, so 1 has those that we have an email address for , 1 with those with mobile , 1 landline and 1 if we have no contact info.
    No entry is duplicated in a brake down sheet if we have more than 1 type of contact information which it goes in is based on priority Email - Mobile - Landline - None ( team 1 are working with these )

    What I want to be able to do is link the complete list with the brake down lists. So if a row is altered it will alter the correlating row in the brake down. It would also need to be able to handle adding rows, removing rows or sorting rows by say account number or alphabetically , without it all getting messed up across the sheets.

    Am I hoping for to much or is this possible?

    I've created a test work book with 100 entries to show, currently its been manually broken down into the other sheets with no links or anything but should visualise what i mean.
    Excel 2010 BTW

    https://www.dropbox.com/s/t2ds3c0dgr...ting.xlsx?dl=0

  2. #2
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex
    MS-Off Ver
    365
    Posts
    5,774

    Re: Is it possible to have a connected summary sheet to brake down sheets

    What is the purpose of the last 4 sheets? Why does the data need to be split out like that rather than just filtered on the main sheet?
    These are questions that would very much dictate which solution is used for this.

    BSB

  3. #3
    Registered User
    Join Date
    11-18-2016
    Location
    ESSEX
    MS-Off Ver
    2010
    Posts
    10

    Re: Is it possible to have a connected summary sheet to brake down sheets

    In answer to your question its basically because different people will be working with different sets of the list at the same time and want just specific filtered lists.


    Ive managed to link 2 sheets with the following VBA code however im having trouble linking more than 2 sheets if someone knows what i need to alter / add

    Private Sub Worksheet_Change(ByVal Target As Excel.Range)
    On Error Resume Next
    Sheets("Has Email").Range(Target.Address) = Target
    End Sub


    on has email sheet -

    Private Sub Worksheet_Change(ByVal Target As Excel.Range)
    On Error Resume Next
    Sheets("Full List").Range(Target.Address) = Target
    End Sub

  4. #4
    Registered User
    Join Date
    11-18-2016
    Location
    ESSEX
    MS-Off Ver
    2010
    Posts
    10

    Re: Is it possible to have a connected summary sheet to brake down sheets

    Just solved this by creating a loop of linked sheets

+ 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. Add Summary Sheet of Other Sheets
    By dalmuti in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-06-2014, 04:10 PM
  2. Sum values from different sheets to summary sheet
    By puttu in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-18-2013, 10:49 AM
  3. [SOLVED] Loop through sheets - pick up formula from same cells each sheet into summary sheet
    By Webbo in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 10-07-2013, 01:43 PM
  4. [SOLVED] Summary sheet - copy cell contents from multiple sheets to one summary sheet
    By jsmity in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-21-2013, 10:32 AM
  5. [SOLVED] Find the summary of a cell connected to the most recent date.
    By tomsmith in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 01-10-2013, 11:28 AM
  6. I need to get max value from different sheets into summary sheet
    By rageshprasad in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-21-2012, 03:15 PM
  7. Create a summary from multiple sheets on a master/summary sheet
    By detribus in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-07-2012, 08:04 PM
  8. Copying a template sheet and putting those multiple sheets data into a summary sheet
    By John Wolfe in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-18-2011, 06:29 PM

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