I am trying to print small labels for a shop
I currently have all my data in hundreds of columns like the image below
img1.jpg
I am trying to make it so i can print all columns into multiple rows on multiple pages similar to below without doing it manually
IMG2.jpg
Can anyone assist at all as to a faster way to do this?
Last edited by jas105; 07-11-2023 at 05:23 AM.
Welcome to the forum.
There are instructions at the top of the page explaining how to attach your sample workbook (yellow banner: HOW TO ATTACH YOUR SAMPLE WORKBOOK). Screenshots are of little practical use as we cannot manipulate them.
A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Try this code;
Right click on your data sheet >view code. Paste it in the blank window that appears and run the macro.
Please Login or Register to view this content.
Hello Croweater
Thank you so much for this, this worked perfectly!
is there anyway to have the three rows all on one page so you dont get the top cut off at all on the page below?
as you can see from the below image the product code at the top is cut off on the page
Attachment 836402
Last edited by jas105; 07-14-2023 at 05:16 AM.
I can't see that attachment but see if this minor mod fits in on your page;
Please Login or Register to view this content.
It didnt seem to work it cuts off the top or bottom rows of each label unfortunately. ive never done anything in this script before
Last edited by AliGW; 07-16-2023 at 02:26 AM. Reason: Please do NOT quote unnecessarily!
Your attachment to post #5 is invalid, so we can't see the problem.
see below image bottom row on multiple pages either gets the top 2 rows or cuts off
is there any way to fix all rows and columns to widths specified so I can then print and Guillotine these all at once?
Attachment 836552
Please follow the instructions for uplodaing a workbook in the yellow box at the top of the page to upload your image so that ALL members will be able to see it. Inline attachments often come up as invalid.
It would really help if you could post a valid attachment.
Here's a screenshot of the attachment that is reporting as invald for some users.
Cant get images to work, however im bascially needing a way to fix all rows and columns to widths specified so I can then print and Guillotine these all at once?
It does work if you follow the instructions at the top of the page - you must be doing something wrong. I know you can do it because of post #1. I did it for you in post #12 so that your helpers can see the issue.
Try changing the 13 I put in the last code grab t0 21. That should give you 5 rows of labels per page.
If that doesn't work, try adding two to the row...(Nrow = Nrow + 2)Please Login or Register to view this content.
(It's hard to count the rows from that attachment).
I guess what I need to know is;
1. On the FIRST page How many FULL rows did it print?
2. On the FIRST page, how many lines of the incomplete row of labels did it print?
OR...make sure I can see the FIRST page in an attachment.
Last edited by Croweater; 07-16-2023 at 03:09 AM.
I have attached the full data that is required to fit across all pages.
I need Each row to be identical heights and widths.
Bascially ill use these as labels that ill print out and Guillotine.
When you run the macro and print the FIRST page, what does it look like and what version of the macro did you run?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks