+ Reply to Thread
Results 1 to 3 of 3

Trying to pull data from multiple sheets to the first worksheet as a quick reference sheet

  1. #1
    Registered User
    Join Date
    05-22-2013
    Location
    seattle
    MS-Off Ver
    Excel for Mac 2011
    Posts
    2

    Trying to pull data from multiple sheets to the first worksheet as a quick reference sheet

    Wow, worst description ever.

    What I would love help on...

    I am creating a master sheet that is a quick reference to know if a contractor has been paid or has an outstanding invoice. There are 20 plus contractor worksheets that have more detailed information about what they are doing, invoice numbers, amounts, received dates, paid dates, etc... Ok, easy, that I can handle...

    What I envision is the first sheet listing all the contractors in column A then the heading for columns B and C would be "Invoices", with B being "Paid/Up-to-date" and C being "Outstanding".
    All I want to do is put an "x" in whichever column is relevant. That would prompt me to go to the Contractor's main sheet for more details. The information would be inputted into the Contractor's detailed worksheet and should manipulate the first worksheet.

    So, for example column G on any given Contractor detailed worksheet is simply headed "Paid Y/N". If there are any "N"s in column G, then the x should go in the "Outstanding" cell. If the entire column is "Y" then the x would go into the "Paid/Up-to-date" cell.

    It seems simple to me but I have NO idea how to do it...have tried somethings that I thought would work but have to defer to the experts, thanks! Roxane

  2. #2
    Valued Forum Contributor
    Join Date
    07-17-2005
    Location
    Abergavenny, Wales, UK
    MS-Off Ver
    XL2003, XL2007, XL2010, XL2013, XL2016
    Posts
    608

    Re: Trying to pull data from multiple sheets to the first worksheet as a quick reference s

    Hi Roxanne

    Sorry to say this, but you have chosen the worst possible layout for your data by having separate sheets.
    You would be much better off if you copied all of your data to a single sheet, and then used Filters to select any Contractor, and then select either Paid or Outstanding.
    A few blank rows at the top with some Subtotal formulae would provide your answers.
    Of you want to post your workbook, it could easily be converted.
    --
    Regards
    Roger Govier
    Microsoft Excel MVP

  3. #3
    Registered User
    Join Date
    05-22-2013
    Location
    seattle
    MS-Off Ver
    Excel for Mac 2011
    Posts
    2

    Re: Trying to pull data from multiple sheets to the first worksheet as a quick reference s

    Thanks Roger, I thought it would be easy to pull data from from a different sheet in the same workbook and have it displayed on the first sheet. I will upload my workbook soon, I'm just finishing inputting some data. Thanks for your quick response!

+ 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