Sequence number cells >0

[b.johnson]

In the attached workbook, column O on the inventory sheet needs to contain a number for each item with a qty greater than zero.

The first item starts with 0, so with the current imported data matching 20 components, I would have 0-19 for component number.

Hope this makes sense...I've confused myself a bit

[b.johnson]

a few asprin later.....

By counting the range above each cell.

Please Login or Register  to view this content.