• Another Thorny Excel Task


    The attaced file is one more step in my attempt to handle the addition of Monday Powerball drawings. Part of it isn’t working.

    On the wkX tab, PBTweet (cell R15) indicates 95 shares, rather than the correct 68 shares as shown in cell F21.

    NOTE: A previous lottery pool, Lottery57 FIX 03.xlsm,  had 95 shares at its conclusion. You can see this file referenced throughout the Name Manager. I’m guessing this is the root of my problem.

    PBTweet gets its value from PBJackpot (cell AS12).  What’s needed is to make PBJackpot pick up the info in F21. This no doubt arises from my meddling with the Name Manager, which I have screwed up in other ways as well. I can point them out when needed, and can probably clean them up myself.

    In the meantime, maybe somebody can help with this specific problem. BTW, the polished solution to my previous request, along with credits, can be found on the Finances tab.

    Lou Sander

    • This topic was modified 1 year, 5 months ago by ussrankin.
    Viewing 3 reply threads
    • #2409874

      Alternate version of the file I attempted to upload before.


      Lou Sander

      • #2409903


        The message being shown in R15 is coming from text in cell AS12. I suspect the text in that cell is populated via the macros. Can you please upload the xlsm version of the file. If that doesn’t work for some reason, just change the xlsm extension to txt and upload it and advise that’s what you’ve done. Once we see the xlsm we should be able to figure out what is happening.


        • #2410742

          Here is the ZIP file.

          The Forum says that .XLSM files are OK to upload, but when I’ve tried to do that, they are rejected.

          (Sorry for the delay. I wasn’t getting your emails. Also this is posted under the wrong comment. It’s too early in the morning.)

          Lou Sander

      • #2409948

        To upload the xlsm, zip it up first.

        cheers, Paul

    • #2410894


      It appears somewhere along the line cell AS12 on tab wkX had its formula overwritten by it’s text at the time. I’ve looked at wk0, wk1, wk2 and the formula in their AS12 are consistent so I’ve put that into wkX AS12 – I think that gives you the result you are looking for. See Lottery58TEST(220107).xlsm in the attached zip file.


    • #2410968

      This may have done it. Good so far, but I’ll let you know after the next Monday drawing.

      Lou Sander

    • #2414831

      I am giving up on this, and starting again from scratch.

      When I created this workbook from a previous one, I unthinkingly copied several pages from the previous workbook. That created automatic links to the previous book. Not understanding how this worked, I dealt with the links in various ways, getting myself deeper and deeper into confusion.

      Far less confused now, I will start again and be more careful about creating unintended links.

      Lou Sander

    Viewing 3 reply threads
    Reply To: Another Thorny Excel Task

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: