Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.04 seconds.

  1. In this Forum, no one can hear you scream.

    In this Forum, no one can hear you scream.
  2. Replies
    12
    Views
    277

    Hi RG Maybe Maud is busy, but I'm sure he...

    Hi RG

    Maybe Maud is busy, but I'm sure he won't mind if I post an unprotected version of the file for you to look at.
    Maud's code is short, sweet, and effective. As always.

    zeddy
  3. Replies
    3
    Views
    84

    Hi buckshot You didn't say what version of...

    Hi buckshot

    You didn't say what version of Excel you are using, so let's start by assuming it's Excel2003.

    You can use this custom function to return the sheetname of a chosen cell:

    ...
  4. Replies
    12
    Views
    277

    Hi Maud I like your method! But, if you copy a...

    Hi Maud

    I like your method! But, if you copy a block of cells, e.g. [k2 : p8], you could then paste that block to cell [a2], thus replacing your 'protected' cells in column [B].
    So, a little more...
  5. Replies
    14
    Views
    217

    Hi RG Your IFERROR and INDIRECT function...

    Hi RG

    Your IFERROR and INDIRECT function solves Lou's issue with 'missing' week sheets.

    Don: Why dummy sheets? Lou said in post#1 that he didn't want to create all the sheets ahead of time. So...
  6. Replies
    8
    Views
    182

    Hi Theodore ..on my system, you don't need to...

    Hi Theodore

    ..on my system, you don't need to click the URL.
    The URL's could be defined elsewhere e.g in hidden columns, or in 'named' cells.
    It is the 'result' of the formula cell (which...
  7. ..let's not remember we were all newbies once. ...

    ..let's not remember we were all newbies once.

    zeddy
  8. Hi Excelnewbie You formula in column [L]...

    Hi Excelnewbie

    You formula in column [L] misses column [B], and, if corrected, will always give the result of 7 (if you think about it). I would recommend changing the col [L] formula to
    ...
  9. Hi RG Don't mention jabs. I hate injections....

    Hi RG

    Don't mention jabs.
    I hate injections.

    I deserve a swift kick in the ghoulies.

    zeddy
  10. Hi Excelnewbie It's hard to understand what an...

    Hi Excelnewbie

    It's hard to understand what an 'easy-to-remember' number 'means'.
    For example, in mathematics, the irony is that the 'more random' you make a number, the more unique it becomes!...
  11. Replies
    14
    Views
    217

    Hi Lou Using a 'sum-across-sheets' method that...

    Hi Lou

    Using a 'sum-across-sheets' method that RG recently posted, you could use a similar method.
    See attached file.
    (Uses 'dummy-hidden' sheets to anchor your start and end points for the...
  12. Hi RG Oops. My eyes are bad! I look at...

    Hi RG

    Oops.
    My eyes are bad!
    I look at attached files when they are posted like in post#2
    I have a blind spot when they are posted like in post#3.
    But on a clear night I can see the moon.
    ...
  13. Hi RG/kweaver Summing across sheets is pretty...

    Hi RG/kweaver

    Summing across sheets is pretty straightforward.

    For example, if you had sheets [Jan] to [Dec], you could have a [Totals] sheet with a formula in say, cell [k2] as:
    ...
  14. Replies
    8
    Views
    182

    Hi Theodore unclehewie in post#2 showed how to...

    Hi Theodore

    unclehewie in post#2 showed how to do this with a custom function.
    Maud showed another way.

    But perhaps an example would make it clear.
    See attached file.
    (This assumes you are...
  15. Replies
    30
    Views
    1,465

    Hi It seems no one picked up my formula error...

    Hi

    It seems no one picked up my formula error in column [I] on sheet [Delivery Log] on my version2 file.
    That formula returns a month value from 1 to 12, so the display will always show Jan.
    I...
  16. Replies
    30
    Views
    1,465

    Hi Don ..if you click the address label again,...

    Hi Don

    ..if you click the address label again, the Supplier list 'goes away'

    zeddy
  17. Replies
    30
    Views
    1,465

    Hi Don ..and following your previous post#3...

    Hi Don

    ..and following your previous post#3 regarding weeknum, I assumed the Analysis Toolpack was NOT installed, so added a custom function weeknumber.
    I used the International Standards...
  18. Replies
    30
    Views
    1,465

    Hi Don Yes, I should have set the 'shape'...

    Hi Don

    Yes, I should have set the 'shape' properties to NOT print. Good spot!

    Did you notice that when you click the Supplier 'address label' to view the 'Supplier list', that the 'up-down'...
  19. Perhaps another way would be to eliminate all the...

    Perhaps another way would be to eliminate all the 'hard-to-remember' phone numbers.
    Then you would be left with the easy ones.

    zeddy
  20. Replies
    30
    Views
    1,465

    Hi Maud I have attached a corrected version of...

    Hi Maud

    I have attached a corrected version of my take posted in #22.
    I separated the Suppliers and Dates to different worksheets in my post#22 v1, but forgot to update the vba code which still...
  21. Replies
    30
    Views
    1,465

    Hi Maud Same thing on five of my PCs - even...

    Hi Maud

    Same thing on five of my PCs - even tried re-installation. Nada.

    zeddy
  22. Replies
    30
    Views
    1,465

    Hi Maud I'm still having problems with my...

    Hi Maud

    I'm still having problems with my Excel2003. It just cannot create ANY activeX controls on a worksheet. This is a new problem. (The fixes for the December activeX fiasco don't work)
    See...
  23. Replies
    2
    Views
    75

    Hi Phil As a first step, try first saving the...

    Hi Phil

    As a first step, try first saving the .xlsb file as .xlsm, then see if that loads OK into MSO 2013.

    zeddy
  24. Replies
    3
    Views
    475

    Hi Pedsy Welcome to the Lounge! When you...

    Hi Pedsy

    Welcome to the Lounge!

    When you make the formatting rule, try removing the dollar $ signs to make the rule 'relative'.

    zeddy
  25. Replies
    17
    Views
    434

    Hi Maud I agree with you all. I don't know...

    Hi Maud

    I agree with you all.
    I don't know exactly why Howard adds bits on the end of his formulas, but in my own personal bill-paying records I've sometimes entered in an 'Amount Paid' cell...
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4