Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.09 seconds.

  1. Replies
    3
    Views
    369

    To add on to Steve's good advice, and if you are...

    To add on to Steve's good advice, and if you are working with Excel 2010, you can also use a brand new function called: Aggregate.

    The Excel AGGREGATE function returns an aggregate in a list or...
  2. Replies
    2
    Views
    1,824

    Tx Cecil. Its working! Cheers

    Tx Cecil.

    Its working!

    Cheers
  3. Replies
    2
    Views
    1,824

    Hi, I was asked this question from a client......

    Hi,

    I was asked this question from a client...

    They have a workbook that has a VBA userform that opens when the workbook is opened (the On Open event) (Lets name this workbook "Source")

    In...
  4. Replies
    9
    Views
    1,125

    Thanks Steve. This does select the entire row...

    Thanks Steve.

    This does select the entire row :)
    But I was actually wanting it to select the cells that make up the record. IE: The selection must not extend out of the lists width. The reason...
  5. Replies
    9
    Views
    1,125

    Tx for the code Jan Karel. This is selecting...

    Tx for the code Jan Karel.

    This is selecting cells in the A column. Is it possible to have the records rows selected? (Just asking :) )

    Appreciate the help.
  6. Replies
    9
    Views
    1,125

    Hi, I need some VBA code to select a user...

    Hi,

    I need some VBA code to select a user determined amount of rows in a list. Say the list is 50 records. The code must prompt the user for an amount of random records to select. If the user says...
  7. Replies
    31
    Views
    1,401

    Thanks guys. Appreciate the replies. Teunis:...

    Thanks guys.
    Appreciate the replies.

    Teunis: I queried this not for me, but for a client I am dealing with. I'll tell them about ASAP. (I have it, and its a great utility)
    Jan Karel: Cheers for...
  8. Replies
    31
    Views
    1,401

    Thanks guys. Appreciate the replies. Teunis:...

    Thanks guys.
    Appreciate the replies.

    Teunis: I queried this not for me, but for a client I am dealing with. I'll tell them about ASAP. (I have it, and its a great utility)
    Jan Karel: Cheers for...
  9. Replies
    31
    Views
    1,401

    Thanks guys. Appreciate the replies. Teunis:...

    Thanks guys.
    Appreciate the replies.

    Teunis: I queried this not for me, but for a client I am dealing with. I'll tell them about ASAP. (I have it, and its a great utility)
    Jan Karel: Cheers for...
  10. Replies
    31
    Views
    1,401

    Thanks guys. Appreciate the replies. Teunis:...

    Thanks guys.
    Appreciate the replies.

    Teunis: I queried this not for me, but for a client I am dealing with. I'll tell them about ASAP. (I have it, and its a great utility)
    Jan Karel: Cheers for...
  11. Replies
    31
    Views
    1,401

    Thanks guys. Appreciate the replies. Teunis:...

    Thanks guys.
    Appreciate the replies.

    Teunis: I queried this not for me, but for a client I am dealing with. I'll tell them about ASAP. (I have it, and its a great utility)
    Jan Karel: Cheers for...
  12. Replies
    31
    Views
    1,401

    Thanks guys. Appreciate the replies. Teunis:...

    Thanks guys.
    Appreciate the replies.

    Teunis: I queried this not for me, but for a client I am dealing with. I'll tell them about ASAP. (I have it, and its a great utility)
    Jan Karel: Cheers for...
  13. Replies
    31
    Views
    1,401

    Thanks guys. Appreciate the replies. Teunis:...

    Thanks guys.
    Appreciate the replies.

    Teunis: I queried this not for me, but for a client I am dealing with. I'll tell them about ASAP. (I have it, and its a great utility)
    Jan Karel: Cheers for...
  14. Replies
    31
    Views
    1,401

    Thanks guys. Appreciate the replies. Teunis:...

    Thanks guys.
    Appreciate the replies.

    Teunis: I queried this not for me, but for a client I am dealing with. I'll tell them about ASAP. (I have it, and its a great utility)
    Jan Karel: Cheers for...
  15. Replies
    31
    Views
    1,401

    Hi, Is there a way to convert references in...

    Hi,

    Is there a way to convert references in selected formulas/functions on a spreadsheet from relative refs to absolute refs? F4 works to cycle through the ref styles, but only for the active...
  16. Replies
    31
    Views
    1,401

    Hi, Is there a way to convert references in...

    Hi,

    Is there a way to convert references in selected formulas/functions on a spreadsheet from relative refs to absolute refs? F4 works to cycle through the ref styles, but only for the active...
  17. Replies
    31
    Views
    1,401

    Hi, Is there a way to convert references in...

    Hi,

    Is there a way to convert references in selected formulas/functions on a spreadsheet from relative refs to absolute refs? F4 works to cycle through the ref styles, but only for the active...
  18. Replies
    31
    Views
    1,401

    Hi, Is there a way to convert references in...

    Hi,

    Is there a way to convert references in selected formulas/functions on a spreadsheet from relative refs to absolute refs? F4 works to cycle through the ref styles, but only for the active...
  19. Replies
    31
    Views
    1,401

    Hi, Is there a way to convert references in...

    Hi,

    Is there a way to convert references in selected formulas/functions on a spreadsheet from relative refs to absolute refs? F4 works to cycle through the ref styles, but only for the active...
  20. Replies
    31
    Views
    1,401

    Hi, Is there a way to convert references in...

    Hi,

    Is there a way to convert references in selected formulas/functions on a spreadsheet from relative refs to absolute refs? F4 works to cycle through the ref styles, but only for the active...
  21. Replies
    31
    Views
    1,401

    Hi, Is there a way to convert references in...

    Hi,

    Is there a way to convert references in selected formulas/functions on a spreadsheet from relative refs to absolute refs? F4 works to cycle through the ref styles, but only for the active...
  22. Replies
    31
    Views
    1,401

    Hi, Is there a way to convert references in...

    Hi,

    Is there a way to convert references in selected formulas/functions on a spreadsheet from relative refs to absolute refs? F4 works to cycle through the ref styles, but only for the active...
  23. Replies
    6
    Views
    625

    Thanks for the advice. I'll give it a go on the...

    Thanks for the advice. I'll give it a go on the original.
    Appreciate the help http://windowssecrets.com/forums/images/smilies/smile.gif
  24. Replies
    6
    Views
    625

    That will work on the attached (modified) file,...

    That will work on the attached (modified) file, but the prob is that the records on the original source file have additional fields of data that will not allow an advanced unique filter. I was...
  25. Replies
    6
    Views
    625

    Hi, I need help with a calculation to...

    Hi,

    I need help with a calculation to calculate how many "individuals" attended which courses. I have attached a spreadsheet with the sample data. TIA for your help.
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4