Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.04 seconds.

  1. Hi Welcome to the lounge. See my attached...

    Hi

    Welcome to the lounge.

    See my attached workbook.
    I have added named cells to set the limits for triggering the emails.
    In the vba routines, for testing I used
    .Display
    change this to...
  2. Replies
    2
    Views
    39

    Hi BudE ..welcome to the lounge. Try this:...

    Hi BudE

    ..welcome to the lounge.

    Try this:


    Private Sub Workbook_BeforePrint(Cancel As Boolean)
    ActiveSheet.PageSetup.BlackAndWhite = True
    End Sub
  3. Thread: enhance macro

    by zeddy
    Replies
    10
    Views
    193

    Hi Don re: "sheet 2 doesn't have order...

    Hi Don

    re: "sheet 2 doesn't have order numbers"

    ..it's in column [L] (before processing), and column [B] (after processing)

    zeddy
  4. Replies
    8
    Views
    142

    Hi kweaver I can't see how this could be done...

    Hi kweaver

    I can't see how this could be done without vba.
    My understanding is:
    You want a new workbook, with 132 sheets, each sheet being a 'speciality' (i.e. sheet tab name=speciality).
    then...
  5. Replies
    18
    Views
    400

    Hi RG Nope. In my sample data, the results I...

    Hi RG

    Nope.
    In my sample data, the results I expect from using the UDF should match the results from the COUNTIFS formula as in cell [E3]

    For my data sample, I amended entries in column [H] to...
  6. Replies
    18
    Views
    400

    Hi Maud ..but it doesn't work in the UK as we...

    Hi Maud

    ..but it doesn't work in the UK as we use dd/mm/yyyy over here.


    zeddy
  7. Replies
    18
    Views
    400

    Hi RG Oops! Yes, you mentioned that in your...

    Hi RG

    Oops! Yes, you mentioned that in your text. Trouble is, when I see an excel formula I sometimes forget to look at the rest.

    As punishment, I have used your method for entering dates into...
  8. Thread: enhance macro

    by zeddy
    Replies
    10
    Views
    193

    Hi OCM If you save an excel file as ".xlsx",...

    Hi OCM

    If you save an excel file as ".xlsx", then all vba is 'removed'.
    Can you post your file as a ".xlsm" file, so that the vba is retained?

    Now, if I 'manually' add your code to the .xlsx...
  9. Replies
    18
    Views
    400

    Hi RG ..I'm thinking you are giving SUMS when...

    Hi RG

    ..I'm thinking you are giving SUMS when MB is asking for COUNTS.
    But still useful.

    ..this is how I did it:
    1. on a spare sheet, format 2 cells as text.
    2. name the cells from and to...
  10. Thread: which is faster?

    by zeddy
    Replies
    19
    Views
    343

    Hi Fred ..what I mean by that is that with a...

    Hi Fred

    ..what I mean by that is that with a Windows OS set up, you could use a windows version of Excel i.e. Excel2007/2010 etc.

    With Apple MAC Excel2011, although there is file compatibility,...
  11. Thread: which is faster?

    by zeddy
    Replies
    19
    Views
    343

    Hi Fred I don't have MAC Excel2011, but I know...

    Hi Fred

    I don't have MAC Excel2011, but I know you can record macros in it. The MAC VBA has the same environment as the Windows VBE as far as I can tell.
    MAC Excel has the Developer ribbon, which...
  12. Thread: which is faster?

    by zeddy
    Replies
    19
    Views
    343

    Hi Fred ..why not persuade the MAC user to...

    Hi Fred

    ..why not persuade the MAC user to upgrade to Excel2011?
    ..then you can use vba, record macros, assign macros to shapes and buttons etc etc.

    zeddy
  13. Replies
    15
    Views
    286

    Hi Maud ..in an ideal world, I would have the...

    Hi Maud

    ..in an ideal world, I would have the range [D2:V13] protected (with or without a password).
    Then, in your code, you could add the line to 'unprotect' this range prior to making changes,...
  14. Thread: which is faster?

    by zeddy
    Replies
    19
    Views
    343

    Hi Fred ..I've often used 'master formula...

    Hi Fred

    ..I've often used 'master formula cell(s)', where, I used vba to 'copy the formula(s) down', and then 'converted the formulas to values'. If the 'prior data' doesn't change, then saving...
  15. Replies
    10
    Views
    298

    Hi skipro Maud and I aren't duelling - we are...

    Hi skipro

    Maud and I aren't duelling - we are playing with Excel, showing different ways of doing things.

    As for your question, the ranges in your first file are 'defined' in the...
  16. Replies
    10
    Views
    298

    Hi Maud What I meant was, if you changed any...

    Hi Maud

    What I meant was, if you changed any of the entries in the named lists, then the menus will immediately show those current items. And if you insert cells within the named ranges, then...
  17. Replies
    15
    Views
    286

    Hi skipro see attached file. I modified...

    Hi skipro

    see attached file.
    I modified Maud's code to clear the data first, before running the code via the button [Run code]
    see sheet named [maud] in attached file.

    On sheet named [zeddy]...
  18. Replies
    10
    Views
    298

    Hi Maud ..no code adjustments required. ...

    Hi Maud



    ..no code adjustments required.

    zeddy
  19. Replies
    10
    Views
    298

    Hi Maud Nice method. I tried a different...

    Hi Maud

    Nice method. I tried a different approach.
    In my attached version, I use the right-click menu for each of the data entry columns.

    When you open the attached workbook (with macros...
  20. Replies
    15
    Views
    286

    Hi Maud ..and you could easily add a warning...

    Hi Maud

    ..and you could easily add a warning message if the entry in the col [A] cell did not match a corresponding 'posting-to' column (or even have a 'new' posting column created automatically)...
  21. Replies
    15
    Views
    286

    Hi Maud ..I would use an 'onEntry' trigger...

    Hi Maud

    ..I would use an 'onEntry' trigger that, when an entry is made in column [B], it would match the corresponding column for the adjacent cell (in col [A] ) and directly 'post' the entered...
  22. Replies
    5
    Views
    166

    Hi Instead of using the long formula.....

    Hi

    Instead of using the long formula..
    =IF(((D9-C9)+(F9-E9)+(H9-G9)+(J9-I9)+(L9-K9))*24>8,8,((D9-C9)+(F9-E9)+(H9-G9)+(J9-I9)+(L9-K9))*24)

    ..you can use this shorter formula:...
  23. Replies
    5
    Views
    166

    Hi welcome to the lounge! see attached ...

    Hi

    welcome to the lounge!

    see attached

    zeddy
  24. Replies
    15
    Views
    286

    Hi Seems like you are processing receipts and...

    Hi

    Seems like you are processing receipts and amounts to their respective columns.
    I would recommend using a dropdown for your entries in column [A], to make sure they are not 'mistyped'. For...
  25. Thread: find col and row

    by zeddy
    Replies
    18
    Views
    551

    Hi Fred Another possible approach is to use a...

    Hi Fred

    Another possible approach is to use a Dell

    zeddy
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4