Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.04 seconds.

  1. Thread: Excel tables

    by Maudibe
    Replies
    23
    Views
    625

    Hi PatKav, Attached is your revised file with...

    Hi PatKav,

    Attached is your revised file with all the coding applied. Your blank rows (Input and Tally) and columns (Index) have all been accounted for so be cautious when inserting or deleting...
  2. Replies
    7
    Views
    141

    or with the match formula: Private Sub...

    or with the match formula:



    Private Sub Worksheet_Change(ByVal Target As Range)
    If Not Intersect(Target, Range("CountOfShares")) Is Nothing Then
    num =...
  3. Replies
    7
    Views
    141

    Lou, Place the following code in the sheet...

    Lou,

    Place the following code in the sheet module of the sheet from your second image. Assuming that you enter your number of shares after the lottery that night, when you update the cell named...
  4. Replies
    7
    Views
    141

    Zeddy, Maybe we should tell Lou about the .pdf...

    Zeddy,

    Maybe we should tell Lou about the .pdf camouflage trick?
  5. [SOLVED] Jaggi, This sped up your code considerably. ...

    Jaggi,

    This sped up your code considerably. Line changes are in blue. You will need to apply them to each section.

    HTH,
    Maud



    Sub Section1()
  6. Thread: Excel tables

    by Maudibe
    Replies
    23
    Views
    625

    PatKov, I am not sure if you are considering...

    PatKov,

    I am not sure if you are considering my code or not but I can only speak for the code that I wrote. It is designed to automatically adjust as you enter new questions. I have also added...
  7. Replies
    17
    Views
    475

    Harry, When it defaults to Personal.XLSB go to...

    Harry,
    When it defaults to Personal.XLSB go to View > Hide then restart excel.

    Maud
  8. Replies
    7
    Views
    141

    Lou, Capturing the value of CountOfShares is...

    Lou,

    Capturing the value of CountOfShares is easy with vba. The event that triggers it is the challenge. What you want to do with the "stored" value will follow. So, before you lay your need,...
  9. Replies
    8
    Views
    196

    Well, I kinda mis-read the question again! I...

    Well, I kinda mis-read the question again! I thought the search was for a value in the entire column A on all of the sheets not just the header. Well maybe it can be used as a solution for another...
  10. Replies
    8
    Views
    196

    Zeddy, I think I know where you are going with...

    Zeddy,

    I think I know where you are going with this.



    For Each ws In ThisWorkbook.Worksheets
    If ws.Visible = True Then
    With ws
    LastRow = .Cells(Rows.Count,...
  11. Replies
    8
    Views
    196

    Alahaye, Here is a sample workbook with 3...

    Alahaye,

    Here is a sample workbook with 3 sheets of data. If you click on the Search button, a search form appears where you can begin entering a search keyword. The entire book will be searched...
  12. Replies
    19
    Views
    613

    Hey Lou, I checked out your Western100...

    Hey Lou,

    I checked out your Western100 website. OUTSTANDING!!! As a Willie Nelson Fan, I linked to "Mammas, Don't Let Your Babies Grow Up To Be Cowboys (Waylon & Willie) w/ lyrics" and then got...
  13. Replies
    17
    Views
    475

    hmw, Follow these steps: 1. Close all...

    hmw,

    Follow these steps:

    1. Close all instances of Excel the open a new instance.
    2. Record a new macro either by selecting the developer tab then Record Macro or clicking the record macro...
  14. Replies
    17
    Views
    475

    Hi Harry, Below is a revised workbook where I...

    Hi Harry,

    Below is a revised workbook where I copied the button on Jan Sheet and pasted on each of the other months. You will be able to sort all the sheets from any one sheet. You could leave...
  15. Replies
    19
    Views
    613

    I'll reinvest my share into Lou's purchasing of...

    I'll reinvest my share into Lou's purchasing of his own Blog site.

    43359
  16. Thread: Excel tables

    by Maudibe
    Replies
    23
    Views
    625

    RG You offer an excellent point with...

    RG

    You offer an excellent point with eliminating the No column. Perhaps the OP would consider the design change in his project. A method of determination may have to be made to distinguish...
  17. Replies
    17
    Views
    475

    Nice pick up Zeddy Should be: LastRow =...

    Nice pick up Zeddy

    Should be:


    LastRow = sht.Cells(Rows.Count, 1).End(xlUp).Row
    LastCol = sht.Cells(1, Application.Columns.Count).End(xlToLeft).Column


    Maud
  18. Thread: Excel tables

    by Maudibe
    Replies
    23
    Views
    625

    RG got me thinking about validation. What if the...

    RG got me thinking about validation. What if the user left a question blank. If all questions must be answered, one way to handle this would be a pop-up indicating that a question was left blank. ...
  19. Thread: Excel tables

    by Maudibe
    Replies
    23
    Views
    625

    RG, Very Nice. Any reason for a double click...

    RG,

    Very Nice. Any reason for a double click instead of a single click? You can have the user just toggle back and forth between Y/N with a single click where a click on the Yes will erase the...
  20. Replies
    17
    Views
    475

    hmw, below is the code to loop through your...

    hmw,
    below is the code to loop through your sheets and sort according to park then date. You can add as many columns ,rows, and sheets as you like. The code is generic to accommodate

    HTH,
    Maud...
  21. Replies
    2
    Views
    177

    Lou, How about =AND($C2>$C4,$C40) as...

    Lou,

    How about

    =AND($C2>$C4,$C4<>0)

    as your conditional formula.

    Maud
  22. Replies
    19
    Views
    613

    Thanks for the follow-up Lou

    Thanks for the follow-up Lou
  23. Thread: Excel tables

    by Maudibe
    Replies
    23
    Views
    625

    Thanks RG. Certainly not a race! The thought...

    Thanks RG. Certainly not a race! The thought just popped when I was reading the post and your clarification made it clear. Please add your thoughts to the project.

    Maud
  24. Lya, See how this looks. I added the Project...

    Lya,

    See how this looks. I added the Project number and name to the subject line in the format of Project#: 12345 | Project Name: xyz. I also fixed the formulas in col C so that they will be...
  25. Lya, Nope, That's perfect. Will work on it

    Lya,

    Nope, That's perfect. Will work on it
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4