Hello to everyone, this is my first question here. I was looking almost everywhere but i couldnt find solution for my problem. Im not good at VBA, and i ask for help. I have one workbook with 35 worksheets, each sheet for one product, all values are in range "A:G". I created multipage userform that can add product to worksheet that i select in combobox, and that all works perfect. Now, i need a macro that can chage status value for all product in given ID range, ID value is in column "A". For example, one ID is 6000550-1 and other is 6000550-10, i want to update all cells in column "E" between that two ID, By default status value is "On Stock" and i want to change it to "Sent"
On my userform i have :
I don t know is this possible like i imagined, but thanks in advance! Any help is welcome.
Screenshot of example is attached below.