If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed.
Hello,
I have a form that users will fill in, and I need to print a set number of labels (all identical) based on the info that is entered.
I have the form set up with data validation and indirect references(Lists on a separate sheet)
Example...
User enters in:
Customer name
Product name
Lot #
PO#
Date made
Number of items
From there I have a separate set of cells that reference the above info formated to how I want the label to appear when printed.
Now, I need to repeat that label the set number of times (# entered in as "number if items") in a label sort of format (not sure if a mail merge will work for this??)
Then, print off and stick identical labels onto each part that is manufactured per PO/Date etc.
Any thoughts on how I can do this without copy pasting 50+ times?
Re: Repeating multiple cells a set number of times to print labels
I tried to attach my sample workbook under "manage attachments" but it will not let me. It says "error - invalid file" It is a .xls file. I am not sure what I am doing wrong.
Re: Repeating multiple cells a set number of times to print labels
I zipped a .xls file (on a mac). I am able to open the link here and it appears as an Excel file - I am having the same problem with my other post as well. The moderator says it opens as a text document, and thought it may have to do with my being on a Mac. I am not sure at all, I am new to using a Mac.
Re: Repeating multiple cells a set number of times to print labels
Is no one able to see my attachment? I am still in need of help with this one. The zipped file opens as an Excel on my end when I open it from the forum.
I would like to figure out a way to repeat my x-amount of identical labels if it is possible to do.
Re: Repeating multiple cells a set number of times to print labels
This all seems quite doable, but your files are not readable. Sorry.
__________________
If you've been given good help, use the icon in that post to give reputation feedback, it is appreciated.
Always put your code between [code] and [/code] tags.
“None of us is as good as all of us” - Ray Kroc “Actually, I *am* a rocket scientist.” - JB (little ones count!)
Repeating multiple cells a set number of times to print labels
to rate it
icon in that post to give reputation feedback, it is appreciated.
Linear Mode
