Print Product Info of Multiple Selected Products

[basfaarts]

At my job we have a nice recipe book that gives information about an article by entering the article number in the right place.
This information is presented by VLOOKUP functions. So if you type in the article number the VLOOKUP functions give the right information of that article.

What I want to do is print the information of several articles that are planned to be produced in one week.
So basically I want to print the article information of all the articles that we produce in one week by one click.
The articles that we produce in one week is available in an excel file.

Can you help me?

[JBeaucaire]

Sure, I'm assuming you have a sheet where you've made a list of article numbers to use, and you need each one of those articles entered into a specific cell one at a time and something printed, yes?

If you post your desensitized sample workbook with all of this laid out, it should be simple to give you exactly what you need.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[basfaarts]

So in this case I want to print both articles

48389
48355

at the same time

[JBeaucaire]

This is a VBA macro to accomplish what you're describing.

Please Login or Register  to view this content.

I've installed it into your workbook (Alt+F11 to open the VBA Editor if you want to see it) and connected it to a button at the top of sheet2. If you change the names of your sheets, you will need to edit the macro, you will see the sheetnames in there.