I have a spreadsheet in VBA that uses sheet1 as a main table data.
On sheet2 on other table a subset of sheet1 of a specific product.
My objective in what I am looking for help is, whenever on the sheet1 makes any changes to that specific product, such as deleting or changing any value, make the change on sheet2 of that value.
In the userform that I use to enter data in the table(sheet1),
I have a listbox that indicate the "ID" of the correspondent row on sheet2, so with that I can reply to your code's msgbox (to delete row).
But it didn't work because the "id" of the row to be deleted on sheet1, does not have the same "ID" on sheet2.
And as it is a table, the ID will change as it is deleted.
What is the most viable change to make that code?
And how to delete another row not specific PPPP product, without the need to answer msgbox.
In other words, how to deal with exclusion depending on whether it is a PPPP product or not?
Thank you very much.
The code I used was from Vcoolio
on in module4.
I send an exemple as test
Sorry, how to send you my test project?