Search:

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

Page 1 of 2 1 2

Search: Search took 0.00 seconds.

  1. Re: How to filter multiple files for latest version of each file

    Sorry for not replying sooner. Been out sick a few days. Looks like I should add your code to mine. But I don't know where to add it. Nor do I know exactly what/how to change your first row to...
  2. Re: How to filter multiple files for latest version of each file

    As I'm new to power query I'm not sure how to get all my files in. I have an excel worksheet that contains all the files. Worksheet has total of 14 columns but I only need to use the 3 I made sample...
  3. Re: How to filter multiple files for latest version of each file

    Now I can see the steps under Applied Steps. But get Expression.Error: We couldn't find an Excel table named 'Table3'.Details:
    Table3

    What is Table 3? looks like it would be a file name. I...
  4. Re: How to filter multiple files for latest version of each file

    When your code was used I got:
    Expression.SyntaxError: Token Eof expected.

    In list of workbook queries I have a warning of Download did not complete.

    Here is my original code that shows all...
  5. How to filter multiple files for latest version of each file

    I am using Power Query in Excel for the first time. Got query to work fine but have too much unneeded data.
    Query combines 1000+ files. Each file has ~150 rows of data. Files are named using serial...
  6. Replies
    13
    Views
    972

    Re: convert excel formula to vba

    OK, this one works perfectly for what I need. I really appreciate all your help Sergio. I never would have figured this out myself.
  7. Replies
    13
    Views
    972

    Re: convert excel formula to vba

    Having to be in a specific cell is not what I was after. What I would like is when A7 has X and E19 has X then E27 would automatically have an X. Second part is if E7 has X and E19 has X then E27...
  8. Replies
    13
    Views
    972

    Re: convert excel formula to vba

    Sergio,

    What do you mean by G10 selected? In my formula and yours the cell to get the X to autofill is E27
  9. Replies
    13
    Views
    972

    Re: convert excel formula to vba

    Put formula in module and did not get any error message or red text. Sadly it still does not work. If I run Macro1 from Excel Macro selection I get Run-time error '1004' Application -defined or...
  10. Replies
    13
    Views
    972

    Re: convert excel formula to vba

    Sergio,

    I put the formula in a module, also tried putting it directly in sheet1. Not sure at all if heading of Private Sub.... is correct. Get a Compile error:Ambiguous name...
  11. Replies
    13
    Views
    972

    Re: convert excel formula to vba

    I have a formula in excel spreadsheet that adds an X when specific criteria are met (Xs and/or Model names in certain other cells). Problem is if X is manually deleted it also deletes formula. So I...
  12. Re: Conditional Formatting Not Working Consistently for All Affected Cells

    Hash marks are done in CF by selecting a color and then a pattern. Cells will accept hashmarking OK. Here's how things are supposed to work: Putting X in A7 adds hash marks. This works. Then an X in...
  13. Re: Conditional Formatting Not Working Consistently for All Affected Cells

    Ford,

    So why won't the good formula work in my real order form?

    Could not get your countif formula to work. Best it did was hash marks in 1 of 4 cells I'm trying to cover with hash marks. Even...
  14. Re: Conditional Formatting Not Working Consistently for All Affected Cells

    Eric, thanks for your reply. I tried your formula and several variations. I can get them all to work with an X in E22, but not with X in D22. Tried using several other cells/columns for X reference...
  15. Re: Conditional Formatting Not Working Consistently for All Affected Cells

    What I have now is that putting an X in a certain cell covers a row with hash marks. Putting X in another cell does nothing. Both cells are identified correctly in formula. I tried this on a blank...
  16. Re: Conditional Formatting Not Working Consistently for All Affected Cells

    I'm still working on solving this issue. I can make conditional formatting work for 1 cell but not for 2 cells side by side. I think it should work by using an AND(OR formula. But it does not work. ...
  17. Conditional Formatting Not Working Consistently for All Affected Cells

    Problem: Conditional formatting not working consistently for all cells defined.


    Scenario: Need to cover a row with hash marks to blank it out when wrong part number is listed.

    Row A37:F37...
  18. Re: Cell Value (content) equals another cell's value/content when a 3rd cell =X

    Both versions did the trick. Thanks.
  19. Cell Value (content) equals another cell's value/content when a 3rd cell =X

    This should be simple but I'm brain dead today.

    I want E5 to equal/match/duplicate what is in A5 if C5 contains an X.
  20. Re: Make Existing Text Box fill yellow when any text written in it

    Got it to work. Wasn't in design mode.
  21. Re: Make Existing Text Box fill yellow when any text written in it

    I tried this on both an Active X text box and a regular insert text box. Didn't work for either one.
  22. Make Existing Text Box fill yellow when any text written in it

    I have an Excel form. In this form is a permanent text box to add comments. I would like the text box to fill yellow whenever any text/number is typed in it, otherwise it should not be filled.
  23. Replies
    6
    Views
    1,451

    Re: Conditional Formatting a Text Box Excel 2010

    I was in View Code.
  24. Replies
    6
    Views
    1,451

    Re: Conditional Formatting a Text Box Excel 2010

    Got Reference Not Valid I thing because I was still in Design mode. However, even out of design mode the box remains white when I type in it.
  25. Replies
    6
    Views
    1,451

    Re: Conditional Formatting a Text Box Excel 2010

    I entered your string like this:
    Sub TextBox1()
    ActiveSheet.OLEObjects("TextBox1").Object.BackColor = RGB(250, 250, 0)
    End Sub

    Got a 'Reference is not valid' message
Results 1 to 25 of 28
Page 1 of 2 1 2