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.
Generate a two sided PDF from a list
-
- 4StarLounger
- Posts: 516
- Joined: 21 Feb 2016, 02:52
Generate a two sided PDF from a list
You do not have the required permissions to view the files attached to this post.
-
- 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
On the Stock Card sheet, only 4 cards fit on a page. Is that really what you want?
Best wishes,
Hans
Hans
-
- 4StarLounger
- Posts: 516
- Joined: 21 Feb 2016, 02:52
Re: Generata a two sided PDF from a list
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.
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.
-
- 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
But it currently looks like this:
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans
Hans
-
- 4StarLounger
- Posts: 516
- Joined: 21 Feb 2016, 02:52
Re: Generata a two sided PDF from a list
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?
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?
-
- Administrator
- Posts: 78236
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
-
- 4StarLounger
- Posts: 516
- Joined: 21 Feb 2016, 02:52
Re: Generata a two sided PDF from a list
Hi Hans,
Sorry i mention wrongly is 9 page in one page.i had attached the file as below for your reference.
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.
-
- 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
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!
The macro is slow because it has to do a lot of work!
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans
Hans
-
- 4StarLounger
- Posts: 516
- Joined: 21 Feb 2016, 02:52
Re: Generate a two sided PDF from a list
Hi Hans,
Thanks a lot for your help,it work perfectly, really unbelievable it can be done...
Thanks a lot for your help,it work perfectly, really unbelievable it can be done...