Prashant1211
New Member
- Joined
- Jun 9, 2020
- Messages
- 33
- Office Version
- 2016
- Platform
- Windows
Dear VBA Experts,
I am trying to create labels in Excel from List. List is on Sheet 1 & label format is in Sheet 2.
what i want is Macro starts picking Value from 2nd Row (sheet 1, A2) and fill in the label format in sheet 2. Then print it and move to next row in sheet 1 till labels for all the rows are not Generated and printed. I want Sheet Page A6 and better if all the labels in can save in PDF format.
Can anyone please help me in creating the macro for the same. Thank you very much for your help.
Regards
Prashant1211
I am trying to create labels in Excel from List. List is on Sheet 1 & label format is in Sheet 2.
what i want is Macro starts picking Value from 2nd Row (sheet 1, A2) and fill in the label format in sheet 2. Then print it and move to next row in sheet 1 till labels for all the rows are not Generated and printed. I want Sheet Page A6 and better if all the labels in can save in PDF format.
Can anyone please help me in creating the macro for the same. Thank you very much for your help.
Regards
Prashant1211