Search:

Type: Posts; User: Lou Sander; Keyword(s):

Page 1 of 20 1 2 3 4

Search: Search took 0.03 seconds.

  1. Replies
    3
    Views
    261

    [SOLVED] The "command button solution" is working so well...

    The "command button solution" is working so well that I'm abandoning further efforts to improve the system.

    Once again, simplest is (usually) best.

    Once again, taking the time to document a...
  2. Replies
    20
    Views
    1,434

    [SOLVED] Now I've fully implemented alan sh's "button"...

    Now I've fully implemented alan sh's "button" idea. It works so well that I'm going to drop any further "improvements".

    Simplest is best.
  3. Replies
    3
    Views
    261

    [SOLVED] Stupidity Resolved

    Sleeping on the problem gave the obvious answer. I've recorded macros to update the share counts on MA, MB, PA, and PB, and put each one on its own command button.

    Now, how to run the macros when...
  4. Replies
    3
    Views
    261

    [SOLVED] I've looked around various Excel help sites....

    I've looked around various Excel help sites. Apparently one can write VBA code that executes when a cell is changed. I think I need such code to plug the current CountOfShares into MAShares (and the...
  5. Replies
    20
    Views
    1,434

    [SOLVED] I've taken note of the "pressing the button"...

    I've taken note of the "pressing the button" suggestion, and it isn't all that bad. I AM looking for that final bit of coolness that automates my workbook even more.

    I've re-done parts of my...
  6. Replies
    3
    Views
    261

    [SOLVED] Lottery Workbook Update

    I've improved my workbook and rethought my needs from the previous thread at Capturing a count that later changes, and am posting the new situation here. Thanks to all who have worked on this matter...
  7. Replies
    20
    Views
    1,434

    [SOLVED] I am re-thinking what I need here. There is more...

    I am re-thinking what I need here. There is more to it that I have been able to specify so far.

    In the meantime, I'm getting ready for a new lottery pool that starts in July. I have to start a...
  8. Replies
    10
    Views
    252

    Fixed it! I put a dollar sign before the C. As...

    Fixed it!

    I put a dollar sign before the C. As in =$C6=""

    Everything seems to work perfectly now.
  9. Replies
    10
    Views
    252

    I did remove all conditional formatting before...

    I did remove all conditional formatting before re-doing it. The results are strange, per the image below. They are even stranger in other parts of the worksheet.

    43834
  10. Replies
    10
    Views
    252

    After Step 2 and before Step 3, I am tempted to...

    After Step 2 and before Step 3, I am tempted to Clear Rules > Clear Rules from Selected Cells. That might clean up some trash. Whadda ya think?
  11. Replies
    10
    Views
    252

    Conditional Formatting (Excel 2010)

    This is driving me crazy.

    In the range D6:AD175, I want the cells in columns D through AD to be have a gray fill color if column C in the corresponding row is blank (it will either be blank or...
  12. Very nice! Thank you. I did it, and it works....

    Very nice! Thank you.

    I did it, and it works. Unfortunately, it seems to have clobbered my list of recent documents. One of these was Normal.dotm.

    I've recovered from that OK, though.
  13. Changing layout in the Quick Styles Gallery

    I think the thing depicted below is called the Quick Styles Gallery, but I can't find its name anywhere.

    43525

    It's a lovely tool, but I need to fix it.

    I almost never use Headings, but I...
  14. Replies
    2
    Views
    156

    [SOLVED] Thanks. I thought I remembered that the codes...

    Thanks. I thought I remembered that the codes updated when the file was saved. I guess it was "printed".
  15. Replies
    2
    Views
    156

    [SOLVED] Automatically put filename in footer

    I'm still not up to speed in Word 10.

    When I create a new document, I want its Footer to contain the filename, a page number, and the date. I've achieved most of this through modifying...
  16. Replies
    20
    Views
    1,434

    [SOLVED] The more I ponder this, the thornier the...

    The more I ponder this, the thornier the situation becomes. Best will be if the gurus can see the whole workbook. I've put a depersonalized copy at a place where anyone can download it....
  17. Replies
    20
    Views
    1,434

    [SOLVED] Thanks! There's no drawing tonight (Monday), so...

    Thanks! There's no drawing tonight (Monday), so I'll test the code tomorrow when there is one.

    I will also ponder your question. It is an important one, since updates regularly occur throughout...
  18. Replies
    20
    Views
    1,434

    [SOLVED] Good stuff! A cell named CountOfShares DOES...

    Good stuff!


    A cell named CountOfShares DOES hold the latest number of shares.
    There's a worksheet named !Participants, and the CountOfShares cell is on that sheet. When someone sends money,...
  19. Replies
    20
    Views
    1,434

    [SOLVED] I've just gotten around to looking at this. I'm...

    I've just gotten around to looking at this. I'm thinking it might be close, but maybe no cigar.

    CountOfShares changes independently of the drawings, depending on when people buy new shares....
  20. Replies
    20
    Views
    969

    [SOLVED] Maudibe's solution seems to be working fine, and...

    Maudibe's solution seems to be working fine, and has handled all of the date transitions it has been faced with. I'm going to assume that it ALWAYS works, and close this thread.
  21. [SOLVED] That does it! I'll use Special Formatting for...

    That does it! I'll use Special Formatting for now, and think more about CF and fill colour.

    The world of Excel is an endless one, and fascinating.
  22. [SOLVED] Very interesting! This variety of special...

    Very interesting! This variety of special formatting is new to me.

    It definitely changes the color when the cell contains something higher than the trigger. It definitely does NOT change the font...
  23. [SOLVED] More... The font to which the cell changes...

    More...

    The font to which the cell changes seems to be Cambria 10 point. That is the "Headline" font that shows up when I look at the Fonts for my current Theme. I don't know much about themes,...
  24. [SOLVED] Conditional Formatting - Changing Font Color Changes Font Face

    I have a worksheet with a column of cells whose font color changes if the cell has a value above 95,000,000. The cells are formatted as 10 point Verdana, with their color AUTOMATIC.

    The...
  25. Replies
    20
    Views
    1,434

    [SOLVED] Lottery31.xlsx - 4.60MB Lottery31.xlsb -...

    Lottery31.xlsx - 4.60MB

    Lottery31.xlsb - 1.59MB

    I'd have to delete about 200 names and other contact information, but I don't think that would take too long.
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4