Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.02 seconds.

  1. Re: Another day another wrinkle- Choose last instance of phrase and delete rest of rows

    It is still Waaaaaaay better than before 8 minutes per Tab and 18 minutes for a complete download.

    Thanks for the tweak on the code.

    DThib
  2. Re: Another day another wrinkle- Choose last instance of phrase and delete rest of rows

    Yes.
    It now takes 1 minute and 55 seconds for the large download. About 1 minute 30 seconds for the individual tabs.
    Thanks for your help!

    You are Sparky!!!
  3. Re: Another day another wrinkle- Choose last instance of phrase and delete rest of rows

    Thanks,

    I think I figured it out.

    DThib
  4. Re: Another day another wrinkle- Choose last instance of phrase and delete rest of rows

    In the code you sent yesterday, it keeps hanging up on several worksheets at this point


    With Sheets("Decontaminate")
    wr = .Range("A" & .Rows.Count).End(xlUp).Row + 1 ...
  5. Re: Another day another wrinkle- Choose last instance of phrase and delete rest of rows

    also, for the fifth sheet, column 27 is of no concern ?


    It could be eliminated if it is hanging things up
  6. Re: Another day another wrinkle- Choose last instance of phrase and delete rest of rows

    It would depend on the number of ID matches, It could be as little as none to typically 95. Approvals on last page are generated by all other work on the same ID. (sign-offs)
  7. Re: Another day another wrinkle- Choose last instance of phrase and delete rest of rows

    Thanks NoSparks,

    I'll try it and let you know.

    DThib
  8. Re: Another day another wrinkle- Choose last instance of phrase and delete rest of rows

    Addendum to above question:

    I have tried this I have included below.
    It only pulls the data on the first logic statement Sheets("Sheet1"). It takes 20 minutes.

    Help!


    Public Sub Big_One()
  9. Another day another wrinkle- Choose last instance of phrase and delete rest of rows

    My latest quandary,

    My file I copy to draw data from is data run everyday. The file runs a new instance anytime anything is added and a row is added with all the data plus the additional...
  10. Replies
    4
    Views
    209

    Re: Adding a waiting 3D animated icon to code

    Thank you,

    I have been trying that code. The animated icon I am using is from the Insert menu images.
    I would like for it to run while the macro is executing code in the back. It takes a couple...
  11. Replies
    4
    Views
    209

    Re: Adding a waiting 3D animated icon to code

    Any ideas?

    DThib
  12. Replies
    4
    Views
    209

    Adding a waiting 3D animated icon to code

    Hello all,

    My code is working as intended.
    There is a long waiting period as a consequence of the code run that I would like to call a 3D animated model I have to just run onscreen while the...
  13. Re: Extremely complex puzzle to find result in a worksheet and use to copy information in another

    Hi NoSparks,

    It works fantastically! Appreciate your patience and knowledge.
    I will work this into the other tabs.

    You Rock and Spark!!

    DThib
  14. Re: Extremely complex puzzle to find result in a worksheet and use to copy information in another

    Thanks for clarifying for me.
    blonde thoughts :).

    Two would encompass both last checks for column 26 (Z) - "Investigate Complaint" and "Review Product History". I am trying to use either to...
  15. Re: Extremely complex puzzle to find result in a worksheet and use to copy information in another

    Thanks for the reply.

    It should copy only 1(one) instance, from the last matching row in "Initial Query Pull" worksheet to "Workable", for each Complaint ID (column B).

    DThib
  16. Re: Extremely complex puzzle to find result in a worksheet and use to copy information in another

    https://app.box.com/s/5i7071l7mx2jcp79iy4m1c8tci799xwk

    OK, it is fixed.

    DThib
  17. Re: Extremely complex puzzle to find result in a worksheet and use to copy information in another

    Sorry, I must have shortened something too much, let me look and I'll reset the dummy workbook.

    DThib
  18. Re: Extremely complex puzzle to find result in a worksheet and use to copy information in another

    Sure.

    https://app.box.com/s/vmzh0dtm9myeormi67zap7j23z4kje1r

    The Macro is Workie.

    As you can tell, the entries on "Initial Query Pull" have a lot of similar information in each row.
    This is...
  19. Re: Extremely complex puzzle to find result in a worksheet and use to copy information in another

    Can anyone help me get the last match to produce the the last matched row?
    Here is the cod. It returns the instances I need but it returns EVERYTHING!

    I need the code to pull the last matched of...
  20. Re: Extremely complex puzzle to find result in a worksheet and use to copy information in another

    I apologize if I have frustrated you.

    It was not my intent.

    Basically,
    The database pulls information into columns A:AS. The draw pulls every instance of every action for every record, this...
  21. Re: Extremely complex puzzle to find result in a worksheet and use to copy information in another

    Hello NoSparks,

    The most narrow result would be column (AK). I would like to pull information from the last entry (row) that would be defined by AK.

    The other columns we have been talking...
  22. Re: Extremely complex puzzle to find result in a worksheet and use to copy information in another

    1.) puts the current date into column "A" of the next row (determined by j) on sheet "Workable"
    Yes
    2.) puts Sheets("Initial Query Pull").Cells(i, 1).Value into column "B" , on whatever row j...
  23. Find result in a worksheet and use to copy information in another

    Hello all,

    The resource feeding one of my workbooks has changed.

    The source now puts an entry everytime it is entered in the database. This results in many lines with almost identical...
  24. Re: VBA identified Tables to compare values and skip if match

    Thanks, it worked.

    DThib
  25. Re: VBA identified Tables to compare values and skip if match

    NoSpark,

    Here it is.
    https://app.box.com/s/4prvoi7h2z4p37imwegekfr27bt62c2r

    Button document
    https://app.box.com/s/y7t4rpxo2fyfr2o65va8wmnzj7x52uep

    DThib
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4