Hi
I would like to take our inventory and create bar codes. However, my formula moving from each row, doesn't go in row order.
For instance:
Row 1, Col A has =IF(ISTEXT(Assets!I2),Assets!I2,) then
Row 1 Col B has =IF(ISTEXT(Assets!I3),Assets!I3,) and
Row 1 Col C has =IF(ISTEXT(Assets!I4),Assets!I4,).
Moving down to the next row, row 2 starts with
=IF(ISTEXT(Assets!I6),Assets!I6,) and not I5. Not sure why.
Barcode Spreadsheet looks like this:
<tbody>
</tbody>
Inventory spreadsheet looks like this:
<tbody>
</tbody>
I would like to take our inventory and create bar codes. However, my formula moving from each row, doesn't go in row order.
For instance:
Row 1, Col A has =IF(ISTEXT(Assets!I2),Assets!I2,) then
Row 1 Col B has =IF(ISTEXT(Assets!I3),Assets!I3,) and
Row 1 Col C has =IF(ISTEXT(Assets!I4),Assets!I4,).
Moving down to the next row, row 2 starts with
=IF(ISTEXT(Assets!I6),Assets!I6,) and not I5. Not sure why.
Barcode Spreadsheet looks like this:
Widget formula: =IF(ISTEXT(Assets!B2),Assets!B2,) | Widget 2 formula: =IF(ISTEXT(Assets!B3),Assets!B3,) | Widget 3 formula: =IF(ISTEXT(Assets!B4),Assets!B4,) |
Widget 4 formula is wrong: =IF(ISTEXT(Assets!B6),Assets!B6,) | Widget 5 =IF(ISTEXT(Assets!B7),Assets!B7,) |
<tbody>
</tbody>
Inventory spreadsheet looks like this:
Serial Number | Description |
NTE231 | Widget |
1254 | Widget 2 |
NT351 | Widget 3 |
5423 | Widget 4 |
NLR921 | Widget 5 |
<tbody>
</tbody>