Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.03 seconds.

  1. Replies
    7
    Views
    102

    yang, You can do this easily with a pivot...

    yang,

    You can do this easily with a pivot table. See the revised spreadsheet. I split your debits with the formula, =IF(I2>0,I2,0) and your credits with the formula =IF(I2<0,I2,0) in columns J...
  2. Replies
    5
    Views
    72

    You could also use the line highlighted in blue:...

    You could also use the line highlighted in blue:



    Sub RefreshPT()
    Sheets("Sheet1").Activate
    Range("B2").Select
    UserValue = InputBox("Enter Date in MM/dd/yyyy format")
    If...
  3. krf, If you copied the text from the internet...

    krf,

    If you copied the text from the internet and pasted into your cells, you often get hidden non-printable formatted characters. Try the clean function: =CLEAN(A1).

    HTH,
    Maud
  4. Replies
    5
    Views
    316

    A couple of questions to answer: 1. Is there ...

    A couple of questions to answer:

    1. Is there naming convention for your 22 sheets?
    2. Are they located in the same folder and are they the only files in the folder or will there be other...
  5. Replies
    12
    Views
    237

    Why do I never take the first piece of bread in...

    Why do I never take the first piece of bread in the bread bag? I dunno!
  6. Replies
    12
    Views
    237

    If humans had a third arm coming out of the...

    If humans had a third arm coming out of the center of their chest, where would automakers place the driver side airbag?
  7. Replies
    12
    Views
    237

    ...Or when you get that momentary hang in your...

    ...Or when you get that momentary hang in your computer, you start clicking a billion things to check if your computer locked up only to find your self wasting more time as those billion things...
  8. Replies
    12
    Views
    237

    Or we say it real slow while over-pronunciating...

    Or we say it real slow while over-pronunciating the word. Like that really does anything!
  9. Replies
    12
    Views
    237

    Questions that have no logical answer

    As the batteries get weaker in the remote, why do we press harder on the buttons???

    Post your "I dunno" question.

    Maud
  10. Replies
    2
    Views
    75

    Just another thought regarding your memory. With...

    Just another thought regarding your memory. With Win7 32 bit, or any other Win 32bit OS you are limited to about 3.2GB of available RAM. If you have onboard graphics, you are sharing what you do...
  11. Replies
    5
    Views
    105

    RG's approach it is very versatile since the date...

    RG's approach it is very versatile since the date on the right side has a stable number of characters (8 numbers) and allows any number of characters to its left. I am sure RG added the intermediate...
  12. Replies
    2
    Views
    75

    Although more of a workaround and not a solution,...

    Although more of a workaround and not a solution, there are 2 things that should reduce Excel hogging CPU cycles.

    You did not mention what type of CPU and the number of cores it contains but if it...
  13. Replies
    23
    Views
    765

    One approach might be to save the values to an...

    One approach might be to save the values to an array variable before clearing them, output sheet to HTML, then place the values back.
  14. Thread: Formula Help

    by Maudibe
    Replies
    5
    Views
    103

    Vernada, Try this formula: ...

    Vernada,

    Try this formula:



    =INDEX(Worksheet!$A$8:$L$5000,MATCH($A6,Worksheet!$E8:$E$5000,0),11)
  15. Replies
    1
    Views
    58

    How about something like this? If Lookup...

    How about something like this?

    If Lookup value=0 then "xx" else Lookup value



    =if((LOOKUP(9E+307,IF(F:F>0,F:F)))-MAX(F:F)=0,"xx",(LOOKUP(9E+307,IF(F:F>0,F:F)))-MAX(F:F))
  16. GG, You mention tabs and workbooks. Do you mean...

    GG,
    You mention tabs and workbooks. Do you mean tabs and worksheets OR are you referring to your window tabs and workbooks on the taskbar?

    If it is the task bar, right click on an empty area...
  17. Replies
    2
    Views
    73

    1. Is there a procedure that needs to be run to...

    1. Is there a procedure that needs to be run to put the data on the sheet?
    2. Is the sheet with the data hidden?
    3. what is the color of the font for the cells (white)?
    4. Is the sheet or the...
  18. Replies
    11
    Views
    151

    RG, Nicely done! A suggestion if I may. If...

    RG,

    Nicely done! A suggestion if I may. If the date is in the format of mm/dd/yyyy then an error will exist because the name of the file cannot contain a "/".

    Consider this tweak:


    ...
  19. Replies
    7
    Views
    180

    Jimmy, Yes, you can delete them once you are...

    Jimmy,

    Yes, you can delete them once you are sure that the code acts the way you expect it. However, if you ever need conversions in the future that do not involve hash tags and you want leading...
  20. Reitz, You did not specify the nature of you...

    Reitz,

    You did not specify the nature of you problem but here are several things we need to do:

    1. Make sure you are not placing a form control button instead of an active x control. With...
  21. Reitz, Borrowing from RG, I amended the code...

    Reitz,

    Borrowing from RG, I amended the code to add in the user's name to the transfer in column 8. As before, the code will transfer as many lines that are present but I added in the code to...
  22. Replies
    4
    Views
    97

    RG, Nice! Your concept makes much more sense...

    RG,
    Nice! Your concept makes much more sense than my approach when used in the Workbook_BeforeClose



    ' Create a global variable to store the default save file format.
    Dim MyCurrentSaveFormat...
  23. This will use your naned ranges that already have...

    This will use your naned ranges that already have your formulas applied:



    Sub ChangeAxisScales()
    Worksheets("Dash2").ChartObjects("Chart 8").Activate
    With ActiveChart.Axes(xlValue)...
  24. Replies
    4
    Views
    97

    How about a backdoor approach? If you enter a...

    How about a backdoor approach? If you enter a "password" on the first input box, the workbook will just close by bypassing the validation of the inputs. (Note: Not tested)




    ' Create a...
  25. Reitz, Once transferred, if you want the...

    Reitz,

    Once transferred, if you want the source data to clear and then close the source workbook, you will need to add the following lines (in blue) as the 3rd and 4th lines to the end in the...
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4