Generate a two sided PDF from a list

JERRY89
4StarLounger
Posts: 516
Joined: 21 Feb 2016, 02:52

Generate a two sided PDF from a list

Post by JERRY89 »

Dear All,

Due to Code 39 barcode is not sensitive to my barcode scanner so i decided to use COPY Link Picture from online barcode generator and paste in Excel. But i have a problem to generate it out as two sided PDF because i am having around 500 spare parts list to copy paste from sheet3 and paste in main page for generate PDF. Is there a method to simplify this copy paste and generate it out as PDF.
You do not have the required permissions to view the files attached to this post.

User avatar
HansV
Administrator
Posts: 78236
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Generata a two sided PDF from a list

Post by HansV »

On the Stock Card sheet, only 4 cards fit on a page. Is that really what you want?
Best wishes,
Hans

JERRY89
4StarLounger
Posts: 516
Joined: 21 Feb 2016, 02:52

Re: Generata a two sided PDF from a list

Post by JERRY89 »

Hi Hans,

You are right 4 in one page,the second page is the duplicate data of the above as i need to print it out as double sided after generate as PDF.

User avatar
HansV
Administrator
Posts: 78236
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Generata a two sided PDF from a list

Post by HansV »

But it currently looks like this:

S0045.png
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans

JERRY89
4StarLounger
Posts: 516
Joined: 21 Feb 2016, 02:52

Re: Generata a two sided PDF from a list

Post by JERRY89 »

Hi Hans,

Is ok...i can try to adjust the alignment.Mine layout shall be in A3 size.Can you give me the sample for me to work out on it?

User avatar
HansV
Administrator
Posts: 78236
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Generata a two sided PDF from a list

Post by HansV »

I'd need to know what EXACTLY you want.
Best wishes,
Hans

JERRY89
4StarLounger
Posts: 516
Joined: 21 Feb 2016, 02:52

Re: Generata a two sided PDF from a list

Post by JERRY89 »

Hi Hans,

Sorry i mention wrongly is 9 page in one page.i had attached the file as below for your reference.
You do not have the required permissions to view the files attached to this post.

User avatar
HansV
Administrator
Posts: 78236
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Generata a two sided PDF from a list

Post by HansV »

See the attached version. You will have to fix the page size before running the macro in the workbook.
The macro is slow because it has to do a lot of work!

Stock Card_xlsx.xlsm
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans

JERRY89
4StarLounger
Posts: 516
Joined: 21 Feb 2016, 02:52

Re: Generate a two sided PDF from a list

Post by JERRY89 »

Hi Hans,

Thanks a lot for your help,it work perfectly, really unbelievable it can be done... :thumbup: :thankyou: