Hi everyone
I have a spreadsheet that controls my wine collection. Now want to use barcodes for inventory management.
Need to print a number of barcodes that match the number of remaining bottles.
Sheet 1 retrieves Wine ID (column A) from another spreadsheet (WineCollection). This value is converted to text with leading zeros (column B).
Column C creates the bar code using a TrueType font
In column D, from another spreadsheet (WineCollection), the remaining bottles of the wine is retrieved.
In the example, I want to create 2 bar codes in row 2, 5 bar codes in row 3, etc.
See desired result
Think I've reached the last page on the internet, in my search for a useful method, without luck.
Can anyone help me please?
This is the source sheet
example 1.PNG
This is the wanted result
example 2.PNG
Bookmarks