Packing Slip Numbers - Increment for selected customer only

  • Hello,

    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.

  • Re: Packing Slip Numbers - Increment for selected customer only

    Yes. There is one packing slip per part shipped.

    There are multiple parts for each customer however the packing slip number increments based on customer. So Customer A will have its own packing slip number set vs. Customer B.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!