I am trying to create a packing slip which has a database of parts and when the part is entered into the packing slip through a drop down list and saved to PDF the packing slip number for that corresponding part will increment by 1.
I have set this up using a table on another worksheet and I am match/index to know which customers part is selected on the active worksheet. However I am having difficulties incrementing all cells with the corresponding customer identifier. I have tried filtering the table to the customer identifier and then increment only the visible, but this unintentionally created more rows in the table.
Any help with the code would be greatly appreciated.