OzGrid Free Excel/VBA Help Forum

The best online resource for all your Excel & VBA requirements

Recent Activities

  • KjBox

    Replied to the thread Macro to filter values.
    Post
    You're welcome
  • dkool

    Replied to the thread Macro to filter values.
    Post
    works fine . Thank you
  • dkool

    Reacted with Like to KjBox’s post in the thread Macro to filter values.
    Reaction (Post)
    Yes it does work, see attached
  • Carim

    Post
    Hello,

    Not totally sure to understand your code ...

    However, once you have properly applied your Split... you can use following modification
    (Code, 8 lines)

    Hope this will help
  • KjBox

    Replied to the thread Macro to filter values.
    Post
    Yes it does work, see attached
  • KjBox

    Replied to the thread Macro to filter values.
    Post
    The code uses "CurrentRegion" for both the Input Products table and Fixed List so should work for any number of rows of either, but I will check.
  • dkool

    Reacted with Like to KjBox’s post in the thread Macro to filter values.
    Reaction (Post)
    If that is what you mean the try the attached file. Click the button on the Input Sheet

    Code assigned to the button
    (Code, 57 lines)

  • dkool

    Replied to the thread Macro to filter values.
    Post
    Hello . Thanks for this. This should work . Just one request , if the code can be made flexible. If I add more products in products column and more items to my fixed list , then currently it doesn't work . If that can be done that will be helpful
  • rory

    Post
    This sort of thing is better in a database. With Access, you could use userforms in Excel to edit/update the data or simply distribute an Access front-end to everyone. With SQL server you can do the same or you can use something like Power Apps to create…
  • phrankndonna

    Post
    We use Office 365, so we do have Access. And I do believe we also have SQL Server.

Unread Threads

    1. Title
    2. Replies
    3. Last Reply
    1. Macro to filter values 8

      • dkool
    2. Replies
      8
      Views
      130
      8
    3. KjBox

    1. Vba split string and paste in next line 1

      • Hanes109
    2. Replies
      1
      Views
      87
      1
    3. Carim

    1. Shared workbook just for user notes 3

      • phrankndonna
    2. Replies
      3
      Views
      88
      3
    3. rory

    1. How can we use VBA/Macros Excel for solving this interesting simulation question? 3

      • MrSimulation
    2. Replies
      3
      Views
      217
      3
    3. Kaper

    1. Run time error 76. Path not found 6

      • RAJESH SHAH
    2. Replies
      6
      Views
      121
      6
    3. Carim