Results 1 to 13 of 13
  1. #1
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: vba excel query (any)

    Hi Zoola, welcome to the lounge.

    Your guess is correct when you said: >I would be guessing a copy of the worksheets are required, if so please email me.

    It is best to keep all attachments and replies public so that other loungers can have the opportunity not only to learn from the replies, but also assist in the solutions. If you can attach a dummy version of the workbook, it will greatly assist with solving the automisation problem. Please note that all attachments must be 100K or less. If necessary zip the Workbook and attach it to the reply!
    Regards,
    Rudi

  2. #2
    New Lounger
    Join Date
    Jul 2005
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts

    vba excel query (any)

    Post deleted by zoola

  3. #3
    New Lounger
    Join Date
    Jul 2005
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: vba excel query (any)

    updated with attachment, many thanks for the welcome.

    edit: if more information is required please advise..this is rather urgent.

  4. #4
    New Lounger
    Join Date
    Jul 2005
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: vba excel query (any)

    rudi?

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: vba excel query (any)

    I'm afraid Rudi will be offline for some days.

    I find your friend's description rather confusing. Let's take it one thing at a time, and start with item 1. "Sum up the total weight in a carton".
    Should the totals be in the Pack Data sheet?
    Number 201 occurs several times. Do you want an overall total for 201, or a separate total for each range such as B21:G51? Will these ranges always contain 31 rows?

  6. #6
    New Lounger
    Join Date
    Jul 2005
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: vba excel query (any)

    i think she wants an overall total which is putten into the hide_pack_summary sheet. I think she said the ranges change, im getting everything by her description, i looked in the xls file and there are some cells in blue...not to sure about anything, you probably have a better idea.

  7. #7
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: vba excel query (any)

    Item 1 asks for a total weight per carton. The "hide pack summary" sheet is set up for totals per code (species), so that is something different.

  8. #8
    New Lounger
    Join Date
    Jul 2005
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: vba excel query (any)

    Can you just have a best guess?

    Ive not to much idea. Perhaps the overall totals are meant to go in the cells in blue? Whatever you can make of it, else if you have specific questions you think I should ask so as I can come back with more information?

  9. #9
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: vba excel query (any)

    The code in the attached text file will create subtotals in the pack data sheet. It probably won't be exactly what your friend wanted, but the ranges in the worksheet are not entirely consistent, so I cannot determine where a listing ends.

    When the data change, the macro will have to be run again.

  10. #10
    New Lounger
    Join Date
    Jul 2005
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: vba excel query (any)

    Many thanks Hans, I will forward this on and see what she says.

    Just wondering if that solution has anything to do with number 2 3 or 4?

    Once again many thanks

  11. #11
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: vba excel query (any)

    The answer to item 1 has nothing to do with items 2, 3 and 4.

  12. #12
    New Lounger
    Join Date
    Jul 2005
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: vba excel query (any)

    Hi Hans,

    What could you suggest for items 2, 3 and 4?

    Again, even a best guess would be most helpfull.

    Many thanks,
    Zoola

  13. #13
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: vba excel query (any)

    I'm afraid that the structure of the "pack data" worksheet makes it difficult to do those. If possible at all, the data should be in one table, with all relevant fields (columns) filled in even if values such as the carton number are repeated. Tallying is MUCH easier then. It would still be possible to create a sheet laid out like the present version for display and printing purposes.

Posting Permissions

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