+ Reply to Thread
Results 1 to 7 of 7

New and Need Help, Multiple Sheets

  1. #1
    Registered User
    Join Date
    06-27-2019
    Location
    Reno, Nevada
    MS-Off Ver
    Excel 2007
    Posts
    4

    New and Need Help, Multiple Sheets

    I use Excel to track orders and sales for sports teams. My formula: =IF(ISNA(VLOOKUP(B2,Roster!$B$2:$D$105,2,0)),"End List",IF(VLOOKUP(B2,Roster!$B$2:$D$105,2,0)=0,"",VLOOKUP(B2,Roster!$B$2:$D$105,2,0))) works fine except... Other formulas I use on the sheet are so large I can't use it on teams with over 40 individuals. My solution is to break it up over multiple sheets. I need the formula above (which I pieced together from a number of tutorials) to: Sheet 1 add names from the roster 1-40, which it does, sheet 2 names 41-81 and so on. Any Ideas?

  2. #2
    Valued Forum Contributor
    Join Date
    04-26-2015
    Location
    Toronto, Canada
    MS-Off Ver
    2010
    Posts
    502

    Re: New and Need Help, Multiple Sheets

    You need a combination of INDEX formulas:
    Please Login or Register  to view this content.
    and
    Please Login or Register  to view this content.
    See the samples in this template with instructions on how it works.
    Attached Files Attached Files
    Uploading an attachment will assist Forum Members in finding the correct Solution for you. Create a dummy worksheet if necessary, add your start data and show where / what your expected results should be. TO ADD A FILE:

    Go to 'Advanced. click on 'Manage Attachments. Select 'Browse & Choose your file, Select 'Upload and then close the Attachment window.

  3. #3
    Registered User
    Join Date
    06-27-2019
    Location
    Reno, Nevada
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: New and Need Help, Multiple Sheets

    BlindAlley, Thank you for the reply. I tried to apply your formulas to what I have, so far, without success. I received the roster today with 113 kids. Is there no way to modify my existing formula for successive sheets to say for example:
    IF($A$2=or< 41) I know my syntax isn't right but I hope it gets the idea across.

  4. #4
    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,893

    Re: New and Need Help, Multiple Sheets

    Will you please attach a SMALL sample Excel workbook (10-20 rows of data is usually enough)? However, please give us an indication of the approximate number of rows of data you want the solution to work with (100, 1000, 100,000 or whatever). Please don't attach a picture of an Excel sheet (no-one will want to re-type all your stuff before starting).

    1. It does NOT have to be your real sheet - mock up a SAMPLE if you need to. But not 1000's of rows!!! It makes manual checking so tedious. Whatever you do... make sure that all confidential information is removed first!!

    2. Make sure that your sample data are truly REPRESENTATIVE of your real data. The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

    3. Make sure that your desired solution is also shown (mock up the results manually).

    4. Try to avoid using merged cells. They cause lots of problems!

    Unfortunately the attachment icon doesn't work at the moment. So, to attach an Excel file you have to do the following: Just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.
    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

  5. #5
    Registered User
    Join Date
    06-27-2019
    Location
    Reno, Nevada
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: New and Need Help, Multiple Sheets

    Hi Glenn,
    Well, I've given myself another hurdle since I'm going to have another photographer and camera there as well. I'll probably assign myself odd numbers and the second camera even.
    I'm sure you wanted to know that.
    I may need to input it manually this time and work through it later.
    Thanks

  6. #6
    Registered User
    Join Date
    06-27-2019
    Location
    Reno, Nevada
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: New and Need Help, Multiple Sheets

    Thank you for the suggestions, I solved this with what I already had, which is what I hoped. The biggest issue here is that I don't really know what I'm doing so I made it more complicated than it needed to be. When I realized that I knew the values on successive sheets but not the names, I could list the order 41-81 and it would fill in the names.

  7. #7
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: New and Need Help, Multiple Sheets

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however the thread title does not really convey what your request is about.

    Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

    Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

    (Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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. Replies: 9
    Last Post: 10-16-2017, 03:25 AM
  2. copy and paste multiple sheets to multiple sheets
    By bjcowen9000 in forum Excel General
    Replies: 1
    Last Post: 07-11-2016, 08:57 PM
  3. Break multiple lists from different sheets in to new files with multiple sheets
    By belesky in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-01-2015, 12:43 PM
  4. Help indexing multiple sheets and matching multiple sheets
    By skell1 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-11-2015, 11:16 PM
  5. Copy same column from multiple sheets to new wkbk with multiple sheets
    By rmcclendon in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-08-2012, 09:17 AM
  6. Merge multiple excels with multiple sheets in a master excel with multiple sheets
    By marchi in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-15-2012, 10:37 AM
  7. Need to Search for Value Across Multiple Sheets, Value Occur Multiple Times on Sheets
    By davidbriansmith in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-23-2011, 12:31 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