+ Reply to Thread
Results 1 to 11 of 11

Excel Help with multiple sheets

  1. #1
    Registered User
    Join Date
    07-16-2012
    Location
    Utah
    MS-Off Ver
    365 ver. 2210
    Posts
    34

    Excel Help with multiple sheets

    Hi all,

    I need some help with something

    I have an excel spreadsheet that has multiple worksheets. The first worksheet is a summary page and the other worksheets are named by state.

    In my summary page I have information that will change from month to month but the header names will stay the same. So what I need is a way to go to the "State" column and read the cell for what state is there and then find the worksheet with that state name, then back on the summary page go to the "County" column and read the cell for what county is there and then find that county name on the worksheet for the state that we found and then grab the "fee" cell from the "state" worksheet and put it in a cell on the summary page.

    Can anyone make sense of that, i'm sorry if that is confusing, hopefully you get what i'm trying to do Please help

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,093

    Re: Excel Help with multiple sheets

    Please post a sample workbook. Thanks
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Registered User
    Join Date
    07-16-2012
    Location
    Utah
    MS-Off Ver
    365 ver. 2210
    Posts
    34

    Re: Excel Help with multiple sheets

    how do i post a sample, sorry very new to all this

  4. #4
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Excel Help with multiple sheets

    To Attach a File:

    1. Click on Go Advanced.
    2. In the frame Attach Files you will see the button Manage Attachments
    3. Click the button.
    4. A new window will open titled Manage Attachments - Excel Forum.
    5. Click the Browse... button to locate your file for uploading.
    6. This will open a new window File Upload.
    7. Once you have located the file to upload click the Open button. This window will close.
    8. You are now back in the Manage Attachments - Excel Forum window.
    9. Click the Upload button and wait until the file has uploaded.
    10. Close the window and then click Submit.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  5. #5
    Registered User
    Join Date
    07-16-2012
    Location
    Utah
    MS-Off Ver
    365 ver. 2210
    Posts
    34

    Re: Excel Help with multiple sheets

    RecordingFees.xlsx

    above is the sample of the workbook

  6. #6
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,093

    Re: Excel Help with multiple sheets

    Something like (untested):

    Formula: copy to clipboard
    Please Login or Register  to view this content.



    Regards, TMS

  7. #7
    Registered User
    Join Date
    07-16-2012
    Location
    Utah
    MS-Off Ver
    365 ver. 2210
    Posts
    34

    Re: Excel Help with multiple sheets

    Nope that didn't work, says the formula has errors

  8. #8
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,093

    Re: Excel Help with multiple sheets

    Whoops ... missing an ampersand ... I said it was untested :-)

    Try:

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Note the additional & " " ... this is because *most* of your data in the State sheets has a trailing space. Virginia Beach City, for example, doesn't. In most cases, it's returning zero because the cell it returns is blank.

    Regards, TMS

  9. #9
    Registered User
    Join Date
    07-16-2012
    Location
    Utah
    MS-Off Ver
    365 ver. 2210
    Posts
    34

    Re: Excel Help with multiple sheets

    Now it's just returning #N/A. I have also taken out all the trailing spaces from every sheet. It doesn't give any errors but just returnes the #N/A

  10. #10
    Registered User
    Join Date
    07-16-2012
    Location
    Utah
    MS-Off Ver
    365 ver. 2210
    Posts
    34

    Re: Excel Help with multiple sheets

    Nevermind i got it to work, Thank you for very much for all your help.

  11. #11
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,093

    Re: Excel Help with multiple sheets

    You're welcome. Just out of interest, what did you do to get it to work?

    Regards, TMS

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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