I receive lists of data which are often 30+ rows deep and 5 columns wide. I need to take 3 rows at a time and transfer the data to a label. Each label being 1 3rd of an A4 sheet. How do I set up to transfer the data from the first 3 rows, print then transfer the data from the next 3 rows, print etc. and end print when the last row is reached. I have attached a sample for reference.
Rog
Have you thought about just doing a mail merge in Word using your Excel file as the source document?
Would be much easier than doing it all in Excel which would require VBA.
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
Hi Dom, no I hadn't thought of a mail merge. I thought vba was the way to go. Will try it tho'
TYVM
You'll need to change your data layout slightly so that the 'A NO' is present on each line of the Excel source file.
Dom
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks