Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.01 seconds.

  1. Re: Formula question.. hopefully not to difficult

    jjj222 is a lender. I want to see line items for anyone who has an open loan with jjj222, but I do not want to review line items where jjj222 is the lender.

    So if borrower XYZ carries a balance...
  2. Formula question.. hopefully not to difficult

    I have a table with 47k records on it.

    Column J has a number of values. I am concerned with the tracking user "jjj222"

    Column D has Principal. Column E has repayment amount.

    What I am...
  3. Thread: Format as number

    by srosk
    Replies
    2
    Views
    180

    Re: Format as number

    This is great, thanks!
  4. Thread: Format as number

    by srosk
    Replies
    2
    Views
    180

    Format as number

    I know to format a cell as a number it should look something along these lines:


    Columns("D:K").Select
    Selection.NumberFormat = "#.00"


    I have the following, and would like values in E:K of...
  5. Replies
    14
    Views
    226

    Re: Find & replace up to certain row

    Yes :) I really appreciate all that you do. Have a great day!
  6. Replies
    14
    Views
    226

    Re: Find & replace up to certain row

    Soo, to answer your question, it appears blank but indeed.. it is not. Which explains why the results weren't working correctly.
  7. Replies
    14
    Views
    226

    Re: Find & replace up to certain row

    So I think I got it... this fills in the N/A value, then deletes everything below where column A is blank :)


    Columns("D:K").Select Selection.Replace What:="", Replacement:=" N/A",...
  8. Replies
    14
    Views
    226

    Re: Find & replace up to certain row

    Ok, my bad. I see what's happening. I copy 395 rows, do vlookups, and delete all rows where the vlookup result is #N/A, using a autofilter command. I think the UsedRange formula is still reading the...
  9. Replies
    14
    Views
    226

    Re: Find & replace up to certain row

    Is there a way for it to determine the row to stop on.. IE: stop at row 86 since row 87 onward is not used?
  10. Replies
    14
    Views
    226

    Re: Find & replace up to certain row

    Thanks.. can check soon. So if cell A86 has a value and D is blank, " N/A" will appear in D86.

    If A87 is blank, will D87 still be updated to " N/A" ? Ideally, it would remain blank...
  11. Replies
    14
    Views
    226

    Re: Find & replace up to certain row

    They're blank cells that it is replacing with ' N/A'
  12. Replies
    14
    Views
    226

    Find & replace up to certain row

    Is there a way for this code to only look until the last populated row in column A vs the entire columns D:K. IE, the data stops on row 84, but the following populates ' N/A' all the way down...
  13. Re: Most effective way to insert vlookup formula?

    I am not so sure I understand, so pardon my ignorance. If column C contains a value in any row (value could be any alphanumeric value)... then if column A is blank, insert column A formula for that...
  14. Re: Most effective way to insert vlookup formula?

    That's what hopefully.. the script can find :).. My vision, is that for each row that has a value in column C, script checks if column A&B are blank.. if blank, insert formula.. if not blank.....
  15. Re: Most effective way to insert vlookup formula?

    Sure, sorry.. simple Vlookup :)

    Column A:

    =VLOOKUP(C4,'A B'!B:D,2,FALSE)

    Column B:

    =VLOOKUP(C4,'A B'!B:D,3,FALSE)
  16. Re: Search for value, display prompt based on results of search.

    You are so knowledgeable. Thank you again!!
  17. Re: Search for value, display prompt based on results of search.

    Magic! Thanks as always, Dante!
  18. Most effective way to insert vlookup formula?

    I have a spreadsheet that I will be manually adding data to columns C:K. Periodically, I would like to run a macro that searches for rows where column C has a value, but column B is blank for that...
  19. Re: Search for value, display prompt based on results of search.

    Hmm?
  20. Re: Search for value, display prompt based on results of search.

    Thanks Alan! I updated:


    If instr(Range("B" & i), "Budget") > 0 then


    To:


    If instr(Range("B" & i), "Budget") Or instr(Range("B" & i), "BUDGET") > 0 then
  21. Search for value, display prompt based on results of search.

    I need somehow to search column B for the word Budget. If the word budget is found, display a prompt that has an OK button, and once selected, macro continues.

    Just looking at formulas, before...
  22. Re: VBA search for duplicates & display warning message

    Written so simply.. thank you!
  23. VBA search for duplicates & display warning message

    I have the following code. Essentially, looking to find any duplicates in column B. The problem, is it continues to duplicate the function. Basically, what I want it to do is once it finds a...
  24. Replies
    3
    Views
    182

    Re: Ok... what's with this minus sign?

    I had no idea about these other types of dashes. Thanks so much!! With your help and updating xlwhole to xlpart on the find/replace code, this is now working correctly. Thank you again for your help!
  25. Replies
    11
    Views
    323

    Re: Performing some data validations.

    Wow. That totally went over my head, I was caught up in defining the variable type. Thank you so much, sorry for being dense.
Results 1 to 25 of 129
Page 1 of 6 1 2 3 4