Search:

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

Search: Search took 0.00 seconds.

  1. Re: Macro to advance to next value in filtered data?

    Gotcha.
    And of course its not as easy as just changing Static to Dim...

    (For some reason, I can't seem to get your code to work.
    With yours I get the error message: Object variable or With...
  2. Re: Macro to advance to next value in filtered data?

    Thanks!
    I was reminded that I had asked this question before and ended up with the following code which is pretty much what Fluff had suggested. I adapted it to my current project and it works...
  3. Macro to advance to next value in filtered data?

    Hello,
    I have a spreadsheet with over 1600 rows of data. In Column A, there are around 250 or so unique values. I currently have column A filtered so that I can just look at the rows with the...
  4. Re: VBA to advance to next unique criteria in Autofilter list

    I GOT IT!

    I figured it out. I had to replace (xlUp) with (xlDown).

    Thanks, again, for your help! It works just like I want it to now.
  5. Re: VBA to advance to next unique criteria in Autofilter list

    That's the thing, it's not progressing. I inserted and button and assigned the VBA to it, and I can sit there and click it repeatedly and it will still only show the first value, "Company A."
    I...
  6. Re: VBA to advance to next unique criteria in Autofilter list

    I DO have a header in row 4 with data starting in row 5. :)

    Thank you for the quick response. The code is not quite working, though. When I run the VBA, it will only go to the first company name...
  7. Re: VBA to advance to next unique criteria in Autofilter list

    Well, ultimately, for each company I need to review the information and then print it out. The information I receive changes every month, so the workbook I am building will allow me to just drop the...
  8. VBA to advance to next unique criteria in Autofilter list

    I am trying to write a macro that will advance to the next unique criteria in an autofilter list.

    I have roughly 2500 rows of data, but only need to filter by one criteria: The company name.
    ...
  9. Replies
    10
    Views
    1,029

    Re: Need VBA Code for Inventory Sheet

    Once again, Sir, you are a Scholar and a gentleman.
    Took me a minute to get it adapted in, but once I did, it works like a charm!

    Thank you!
  10. Replies
    10
    Views
    1,029

    Re: Need VBA Code for Inventory Sheet

    I have figure out the basic steps to get what I want using an ElseIf clause, but I run into the problem of the range being static and not dynamic.
    If I leave LastRow defined as it is, any NEW...
  11. Re: Excrutiatingly slow insert/delete times using table and defined names

    Admittedly, I haven't looked at your file yet, but what size is the file as a whole?

    I had the same problem with a sheet I am working on and the problem ended up being that I had copied multiple...
  12. Replies
    10
    Views
    1,029

    Re: Need VBA Code for Inventory Sheet

    Forgot to mention that I added a quick "IF" statement if there was only one entry on the voids sheet. If there was only one entry, the code broke down.
  13. Replies
    10
    Views
    1,029

    Re: Need VBA Code for Inventory Sheet

    Hello,
    So the code is still working great, even though I have been playing with it. :rolleyes: The higher ups wanted to see a bit more functionality added to to it and it was relatively easy to...
  14. Replies
    10
    Views
    1,029

    Re: Need VBA Code for Inventory Sheet

    That works PERFECTLY! Thank you!

    And I am totally tempted to keep that exact message in the message box, too!
  15. Replies
    10
    Views
    1,029

    Re: Need VBA Code for Inventory Sheet

    Just bumping the post...
  16. Replies
    10
    Views
    1,029

    Need VBA Code for Inventory Sheet

    Hello all. This is my first port here and I am hoping you can help. I am writing an inventory sheet for my company to track some serialized items. In this sheet, I need to include a tracking page for...
Results 1 to 16 of 16