kznmrexcel
Board Regular
- Joined
- Jun 16, 2010
- Messages
- 86
- Office Version
- 2016
- Platform
- MacOS
I have two sheets in my Excel file for labels with specific letters to be printed. I need to print out various amounts of labels for each letter, so one sheet is like an order form, called labelCount. It looks like this:
So I need to populate column A on the sheet called letters2print like this:
A
A
A
A
A
A
A
A
B
D
Is there a way to automate this on the letters2print sheet?
TIA
count | letters |
8 | A |
1 | B |
C | |
1 | D |
So I need to populate column A on the sheet called letters2print like this:
A
A
A
A
A
A
A
A
B
D
Is there a way to automate this on the letters2print sheet?
TIA