OzGrid Free Excel/VBA Help Forum

You're welcome

works fine . Thank you

Yes it does work, see attached

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

Yes it does work, see attached

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.

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)

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

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…

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