+ Reply to Thread
Results 1 to 3 of 3

Multiple sheets sorting without affecting headline sheet

  1. #1
    Registered User
    Join Date
    05-14-2014
    Location
    Kent, England
    MS-Off Ver
    Microsoft Office Professional Plus 2016
    Posts
    20

    Multiple sheets sorting without affecting headline sheet

    I will setup a workbook that that contains a different sheet for each month
    People will be listed with amounts next to them
    Each person will have an entry on each months spreadsheet
    There will be a main headline sheet which will refer to each person and their amounts on all of the other worksheets

    Can we have a main sheet that refers to all the other sheets but isnt affected if you want to sort the sheets?
    Last edited by Delanos123; 03-04-2015 at 11:16 AM.

  2. #2
    Registered User
    Join Date
    12-30-2014
    Location
    Canada
    MS-Off Ver
    2010
    Posts
    31

    Re: Multiple sheets sorting without affecting headline sheet

    There are many ways to do this, but the short answer is yes you can refer to all the other sheets and it wont matter if you change the order of the sheets.

    If you reference the sheet and cell specifically it will not matter what order your sheets are in, as excel will look for that sheet name, and that cell address and return the value.

  3. #3
    Registered User
    Join Date
    05-14-2014
    Location
    Kent, England
    MS-Off Ver
    Microsoft Office Professional Plus 2016
    Posts
    20

    Re: Multiple sheets sorting without affecting headline sheet

    Thanks so much Ill be looking at this over the nest day or so and may come back with any queries
    Much appreciated knowing im on the right track

+ 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. Simultaneously sorting data in ranges on multiple sheets based on criteria on one sheet
    By Chris Greensmith in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-10-2015, 06:40 AM
  2. [SOLVED] Sorting data from a master sheet to multiple sheets depending on values in a given column
    By kodos10 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 05-30-2013, 05:46 AM
  3. Replies: 0
    Last Post: 08-08-2012, 10:20 AM
  4. Replies: 2
    Last Post: 10-07-2011, 03:15 AM
  5. [SOLVED] Kill all formulas on all visible sheets w/o affecting sheet formatting
    By Max in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-02-2005, 01:06 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