Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.03 seconds.

  1. Replies
    11
    Views
    212

    z, Here is the revised file that will: 1....

    z,

    Here is the revised file that will:
    1. Append the text to the Master sheet
    2. Convert the numbers in column E as you indicated.
    3. Copy and append each line to the worksheet indicated by...
  2. Replies
    11
    Views
    212

    Working on it z. Will have solution completed...

    Working on it z. Will have solution completed tonight or tomorrow
  3. Replies
    7
    Views
    166

    I would have never guessed there would be 50k+...

    I would have never guessed there would be 50k+ rows :)
  4. Replies
    16
    Views
    429

    hmw, The vital signs I entered went from...

    hmw,

    The vital signs I entered went from normal to hypertensive, tachycardic, febrile, and obese with the next set swinging in the other direction of hypotensive, bradycardic, hypothermic, and...
  5. Replies
    16
    Views
    429

    Probably because you have 5000 rows for each on...

    Probably because you have 5000 rows for each on the 5 graphs and that I most likely did not use the most efficient method in my code.

    After playing with this, I found another option you have to...
  6. Replies
    11
    Views
    212

    z, Your welcome. Getting the file name...

    z,

    Your welcome. Getting the file name conversion should be simple enough with a Vlookup from the conversion table. From the zipped CSV file would I be correct to say that you wanted the 4...
  7. Replies
    11
    Views
    212

    z, Sounds doable. Can you provide the...

    z,

    Sounds doable. Can you provide the conversion list of B col values to sheet tab names. If you are sending the values to their perspective worksheet then creating workbooks from them, does it...
  8. Replies
    7
    Views
    166

    foncesa, Change the line: Dim I As Integer,...

    foncesa,

    Change the line:

    Dim I As Integer, J As Integer

    to

    Dim I As Long, J As Long
  9. Replies
    16
    Views
    429

    Lex, The code needs to be placed in the module...

    Lex,

    The code needs to be placed in the module belonging to Data Sheet. You have placed it in a standard module.

    Maud

    40029
  10. Replies
    14
    Views
    242

    For Rory's code to work, the lines: ...

    For Rory's code to work, the lines:


    wkbDSL.Range("B3").PasteSpecial Paste:=xlPasteValues, Operation:=xlMultiply

    need to be changed to

    wkbDSL.ActiveSheet.Range("B3").PasteSpecial...
  11. Replies
    11
    Views
    212

    zmagic, If needed, here is a different...

    zmagic,

    If needed, here is a different approach from Zeddy's. The code will append the text to the Master sheet and convert the numbers in column E as you indicated. It will then copy and append...
  12. Replies
    14
    Views
    242

    A few things to shorten the code further: 1. ...

    A few things to shorten the code further:
    1. After opening the source workbook, once you reactivate the main workbook (ThisWorkbook) you do not have to activate it each time you copy from the...
  13. Replies
    16
    Views
    429

    Lex Vs. Harry, Until you get things...

    Lex Vs. Harry,

    Until you get things straightened out, you can use this code as a workaround. Place in the Data sheet's module. When the date is entered in the next row in column A, the ranges...
  14. Replies
    5
    Views
    133

    Silencer, Following the same concept of...

    Silencer,

    Following the same concept of changing the sheet tab color when a cell change was made to a specific cell:

    If you wish to test the conditional formatting of the cell to determine if...
  15. Replies
    5
    Views
    133

    Silencer, This code will check cell A1 against...

    Silencer,

    This code will check cell A1 against the current date when the workbook is opened. If within 1 week due, the sheet tab will turn red else the sheet tab will have no color. Change [a1]...
  16. Replies
    7
    Views
    166

    Simple change of the 8 to a 7 in line 7 HTH...

    Simple change of the 8 to a 7 in line 7

    HTH
    Maud



    Public Sub FormatCells()
    Dim I As Integer, J As Integer
    LastRow = ActiveSheet.Cells(Rows.Count, 4).End(xlUp).Row
  17. Replies
    3
    Views
    111

    Check out this thread. ...

    Check out this thread.

    http://stackoverflow.com/questions/9879825/how-to-add-a-reference-programmatically-vba-excel

    Coupled with some code to find your excel version you can reference the...
  18. Replies
    3
    Views
    108

    Rathril, I would seriously reconsider buying...

    Rathril,

    I would seriously reconsider buying books for this topic. The move away from paper has been a growing endeavor because it is so cost effective to publish on line. Let's face it, VBA...
  19. Replies
    7
    Views
    166

    foncesa, This code will increment the numbers...

    foncesa,

    This code will increment the numbers in the rows starting at column H using the parameters in Col D and E. It will format each of the cells with leading zeros to have a 6 decimal number....
  20. Replies
    2
    Views
    87

    Derf, I put together a sample sheet with data....

    Derf,

    I put together a sample sheet with data. I am not sure of what kind of data you are using but the following code will adapt. The borders will be created just prior to printing based on the...
  21. Rathril, I believe this will do what you want....

    Rathril,

    I believe this will do what you want. Click on the button on the Day sheet to copy the row to the WEEK and MTD sheets. I also corrected your formulas so you do not get the #DIV/0!...
  22. R2R, I think this should do it Sub...

    R2R,

    I think this should do it



    Sub PrintFooters()
    '-----------------------------------------------
    'REMOVE FOOTER AND PRINT PAGES 1-2
    ActiveSheet.PageSetup.CenterFooter = ""
  23. Replies
    6
    Views
    550

    Dev, Placing this code in the sheet's module...

    Dev,

    Placing this code in the sheet's module will take any value placed in column B, whether manually or programmatically placed there, and enter it into cell D1. Your Vlookup formula will...
  24. Replies
    6
    Views
    550

    Dev, If you could post a sample of your...

    Dev,

    If you could post a sample of your vlookup, which columns would be hidden, which values will be automatically filled, and where you want the new value to be placed, it would be most helpful
  25. Zeddy, Then perhaps this is the fastest way...

    Zeddy,

    Then perhaps this is the fastest way yet to provide a method to let the user select the thousands of available colors. Clicking on a country will open the Edit Color Dialogue box. The...
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4