top of page
Spreadsheet Tools with More Leverage
Unique ID
This function automatically generates a Unique ID which is the concatenation of all parent part numbers with the part number at a particular line item.
When the function is selected, the form appears, which allows a user to select a source column, which is typically a part number column. Once selected, the user can click 'OK'.
A message box appears alerting the user that the results will not be unique if the BOM is packed, i.e. when quantities are greater than zero.
A column with the 'UID' appears in the first column to the right of the table. Each successive parent is separated by two colons, e.g. "::"
bottom of page