Results 1 to 10 of 10

Thread: Getting a result from (client) worksheet in another (Account) worksheet, help Please?

  1. #1

    Getting a result from (client) worksheet in another (Account) worksheet, help Please?



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Please can someone help me out here: I have about 10 to 11 worksheets created (in Excel 2010) as client worksheets with their names and the lists of items sold on each of the client worksheet etc. and have another worksheet created which I called Account worksheet, I want the number of items sold in all the client worksheets result in this Account worksheet and the total money paid from the client worksheets result in the Account worksheet. Please how can I achieve this aim?
    Thanks you help.

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,437
    Articles
    0
    Excel Version
    Excel 2016
    Can you post a small sample workbook showing what you need? I am not sure how you want to summarize.


  3. #3

    Getting a result from (client) worksheet in another (Account) worksheet, help Please?

    Thanks for concern, here is the attachment of the Excel worksheets, you can see that every worksheet with its client name has its own sells and calculation and the last worksheet is named Account worksheet, I would want the total result of the number of ink sold from each of the Client worksheet to result in the Account worksheet,also the total money paid from every client worksheet to totalize in the Account worksheet.
    thanks for help.
    Attached Files Attached Files

  4. #4
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,437
    Articles
    0
    Excel Version
    Excel 2016
    Do you mean these?

    =SUM('Mor Diagne:Moussa'!C3)

    =SUM('Mor Diagne:Moussa'!H3)


  5. #5
    Would this be applied in the Account/Master worksheet where I want the total result from client worksheet to appear? How do I identify/tell the Account or Master worksheet which/where the result comes from. I mean how do I tell the Master worksheet which client worksheet owns a particular result,

  6. #6
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,437
    Articles
    0
    Excel Version
    Excel 2016
    Those formulas just give total sum of specific cell on all sheets.

    If you want specific numbers from each client, then first list the clients in your summary sheet

    Say you listed them in A2 down, then in B2:

    =INDIRECT("'"&A2&"'!C3")

    copied down will get each client's quantity, from C3 and

    =INDIRECT("'"&A2&"'!H3")

    copied down will get each client's total cost from H3


  7. #7
    Thank you , I will work in out when done will let you know

  8. #8
    Sorry would it be possible for you to edit that Excel sheets (and send back to me) using the Account sheet as Master sheet to keep records of all the rest client sheet ink quantity and amount paid.
    that will give me a clue to work it out, If this will not be a burden to you.

  9. #9
    I'm kind of getting it, thank you.

  10. #10
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,437
    Articles
    0
    Excel Version
    Excel 2016
    Sorry, I haven't been around lately. Did you resolve this?


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •