Search:

Type: Posts; User: skipro; Keyword(s):

Page 1 of 8 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    10
    Views
    255

    Maud and zeddy, Thanks. This is like dueling...

    Maud and zeddy,
    Thanks. This is like dueling scripts [as in dueling banjos].

    One last question about the original file which I had attached and which I have again attached for convenience. In...
  2. Replies
    16
    Views
    248

    Maud, Thanks. I would like it case insensitive....

    Maud,
    Thanks.
    I would like it case insensitive.
    Are you aware that if an invaild entry is placed in A your message appears and if oked, or if an entry in A is deleted, the cell goes blank. Then if...
  3. Replies
    16
    Views
    248

    Zeddy, Column A works fine, but column B does...

    Zeddy,
    Column A works fine, but column B does not update D-I unless I update/refresh col A. Can this extra step be eliminated so if I change value in col B it updates D-I spontaneously? It appears...
  4. Replies
    10
    Views
    255

    dropbox list limitations, work around

    I have become aware of the 8 row limits [without scrolling] in a dropbox list. Apparently a combobox approach overcomes this limitation.
    I have an example that works but I need help to modify it.
    ...
  5. Replies
    16
    Views
    248

    Maud, Again thank you. Using your last...

    Maud,
    Again thank you.

    Using your last revised sample, if I change a value in "A", it adds "B" in "D-I" appropriately, great. But it leaves the old value in "D-I", not so great. I do not know...
  6. Replies
    16
    Views
    248

    Maud, Thanks. Easy enough [when you know what...

    Maud,
    Thanks. Easy enough [when you know what you are doing].
    Since I cannot predict the number of row entries, and other formulas will probably be entered below this section, such as subtotals...
  7. Replies
    16
    Views
    248

    copy value to corresponding cell/column

    See attached sample file.
    Column "A" & "B" will be added/changed manually.
    Row 1 does not change
    I need to copy value of "B" to corresponding column [D to I]which matches the value in same row as...
  8. Replies
    20
    Views
    790

    Maud, Thanks. This works but I have lost the...

    Maud,
    Thanks. This works but I have lost the ability to go [click] through my options, essentially in an endless loop as I could before. Now when I use "Shft/Ctrl" and clicking through the choices,...
  9. Replies
    20
    Views
    790

    I am using a modification of Maudibe's script...

    I am using a modification of Maudibe's script above but I find I unintentionally click on cells which changes their intended values. How can I prevent these unintentional changes. Can the cells be...
  10. RG & Rory, Thanks.

    RG & Rory,
    Thanks.
  11. add text before formula returning currency format

    Formula is =Max(J:J) and it returns a currency format " $2,000" [without the quotes]
    I want to add text [GGH] before the return and keep the currency format and see this in the cell - "GGH $2,000"...
  12. Maud, That is the problem, I cannot set it up...

    Maud,
    That is the problem, I cannot set it up the way I want, 2 screens in 1 instance of Excel. When I select "new window", it opens a new window in another instance of Excel.
    Is there a setting...
  13. http://windowssecrets.com/forums/showthread.php/15...

    http://windowssecrets.com/forums/showthread.php/158740-keep-rows-in-view?highlight=skipro
  14. View side by side in Excel 2013 not same as 2010

    In Dec 2013 I requested help with this. I wanted a side by side view so I could scroll up/down on part of a sheet while seeing other rows of that sheet [or other sheets]. I needed independent up/down...
  15. Replies
    20
    Views
    790

    RG, Interesting, did not see that. Maud, ...

    RG,
    Interesting, did not see that.
    Maud,
    That is what I was seeing, but did not know why. I thought it might have created a continual looping and that was why it would not advanced with...
  16. Replies
    20
    Views
    790

    Maudibe, I am trying to understand your code. ...

    Maudibe,
    I am trying to understand your code.
    Please explain the lines:
    (a1).select
    If eliminated the scripts stops at that point. Is this to prevent a loop?
    Thanks.
  17. Replies
    25
    Views
    871

    Maudibe, Thanks. As you say, these things...

    Maudibe,
    Thanks. As you say, these things continually evolve, especially if they are successful. My main sheet got too busy. These changes also helps me understand the code and approach since my...
  18. Replies
    25
    Views
    871

    Maudibe and dguillett, If data is on sheet...

    Maudibe and dguillett,
    If data is on sheet "daily" and I need the return on sheet "mos sum", how do I change the scripts?
  19. Replies
    25
    Views
    871

    When I run your script, it copies the font format...

    When I run your script, it copies the font format in "B". tried it several times, same result. dguillett's script does not do this.
    see attached 1st 3 returns up to line 43
  20. Replies
    25
    Views
    871

    Thanks for help and this info. To help me...

    Thanks for help and this info.
    To help me understand this better, what triggered this clarification? What does this tell me besides the literal statement? Are you saying dguillett's script does it...
  21. Replies
    25
    Views
    871

    maudibe and dguillett Thanks Maudibe's script...

    maudibe and dguillett
    Thanks
    Maudibe's script copies font format from corresponding column B; color, bold, position in cell[center].
    How is this happening? Where in the script does this occur?...
  22. Replies
    25
    Views
    871

    Folks, You are missing my objective. I do not...

    Folks,
    You are missing my objective. I do not want the Min/Max, I want the first and last for each month. Column A is dates and is in order, column B is data/numbers and is NOT in ascending or any...
  23. Replies
    25
    Views
    871

    unclehewie, Thanks. Is there a solution that...

    unclehewie,
    Thanks. Is there a solution that does not involve the extra columns? Can this be done with a single formula?

    dguillett,
    Confused with your reply. Please explain. Thanks.

    Is...
  24. Replies
    25
    Views
    871

    find first and last values with conditions

    Column A is dates in order spanning several years, column B are numbers.
    I need the sum of the last number minus the first number for each month and year.

    I can set the month/year condition with...
  25. RG, My Uninstall button was greyed out because...

    RG,
    My Uninstall button was greyed out because I did not have "Client for MS Networks " highlighted. Again, everything works..
    My OS just does not recognize this as Wi-Fi, to SOME extent. Enough...
Results 1 to 25 of 188
Page 1 of 8 1 2 3 4