Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.04 seconds.

  1. Replies
    21
    Views
    359

    See? Those prefixes will get you everytime! ;)

    See? Those prefixes will get you everytime! ;)
  2. Replies
    3
    Views
    31

    A variation of the sample above would be to...

    A variation of the sample above would be to replace the lookup value in the match formula with a cell reference:

    B12= {=INDEX(B4:B9,MATCH(A12,RIGHT(A4:A9,3),0))}

    By changing the value in A12...
  3. Replies
    8
    Views
    99

    RG, Your method will also allow the user to...

    RG,

    Your method will also allow the user to keep tabbing across the sheet with no "automatic carriage return" at some point which is what I think MNN is trying to achieve hence, he tried...
  4. Replies
    21
    Views
    359

    RG, Shouldn't your variable Dim zWkbDest(1...

    RG,

    Shouldn't your variable

    Dim zWkbDest(1 To 21) As Workbook

    be declared as a string as in

    Dim zWkbDest(1 To 21) As String
  5. Replies
    3
    Views
    31

    Seba, Another approach is an Index/Match array...

    Seba,

    Another approach is an Index/Match array formula:

    Cell B12: {=INDEX(B4:B9,MATCH("MFT",RIGHT(A4:A9,3),0))}

    40159

    Enter the formula =INDEX(B4:B9,MATCH("MFT",RIGHT(A4:A9,3),0)) into...
  6. Replies
    3
    Views
    73

    Maybe changing the line 6 in post #3 from: ...

    Maybe changing the line 6 in post #3 from:



    ActiveSheet.UsedRange.Cells.UnMerge

    To

    ActiveSheet.UsedRange.Offset(8, 0).Cells.UnMerge
  7. Replies
    8
    Views
    99

    RG, Berton Makes a good point. Since you are...

    RG,

    Berton Makes a good point. Since you are running 2013, it may function differently for you than my 2010 version
  8. Replies
    8
    Views
    99

    RG, That works only if you start in column A. ...

    RG,

    That works only if you start in column A. If you start at D1, for example, then tab with entries, pressing enter will return you to D2 in column D where you started not A2.

    Maud
  9. Replies
    3
    Views
    73

    Rathril, Not sure if this is what you are...

    Rathril,

    Not sure if this is what you are looking for but the following code will unmerge your cells and setup your data so a vlookup could be performed.

    HTH,
    Maud

    Before Code:
    40147
  10. Replies
    8
    Views
    99

    MNN, There is no way without VBA to do what...

    MNN,

    There is no way without VBA to do what you are looking to do that I am aware of. Place the following code in your worksheet's module. In this example, when you enter data into a cell in...
  11. Replies
    12
    Views
    354

    foncesa, See if this is what you want to...

    foncesa,

    See if this is what you want to accomplish
  12. Replies
    12
    Views
    354

    foncesa, See if these changes are what you are...

    foncesa,

    See if these changes are what you are looking for. The header will adjust to the columns used.

    HTH,
    Maud
  13. Replies
    16
    Views
    448

    z, There is a hidden sheet called "Conversion"...

    z,

    There is a hidden sheet called "Conversion" that is used for the Vlookup. I have also added some settings on this sheet that will control the number of columns to copy to the number conversion...
  14. Replies
    16
    Views
    448

    z, So, instead of appending the sheet in the...

    z,


    So, instead of appending the sheet in the master file and overwriting the CVS, you would like to overwrite the sheets in the master file with the new data then append to the csv files? ...
  15. Replies
    13
    Views
    347

    Lou, Since Form controls are not active X...

    Lou,

    Since Form controls are not active X controls and cannot encapsulate VBA code, they were outside the scope of this topic. See the following link

    http://support.microsoft.com/kb/291073
  16. Replies
    8
    Views
    230

    Derf, My first code uses the UsedRange...

    Derf,

    My first code uses the UsedRange method. UsedRange is dependent not only by data but also dependent on formatting, comments, etc. On your sheet, you may have cleared some cells of data but...
  17. Replies
    16
    Views
    448

    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...
  18. Replies
    16
    Views
    448

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

    Working on it z. Will have solution completed tonight or tomorrow
  19. Replies
    12
    Views
    354

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

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

    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...
  21. Replies
    16
    Views
    870

    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...
  22. Replies
    16
    Views
    448

    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...
  23. Replies
    16
    Views
    448

    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...
  24. Replies
    12
    Views
    354

    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
  25. Replies
    16
    Views
    870

    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
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4