Here is the link to file
Situation here is similar to this one
Actually "ID" is the main Identity.
I am using Vlookup for calling students data and picture.
Actually these are students cards. For printing purpose,
All I want is10 cards to be printed on single page.
As you can see that output is very small size.
Page size must be A4 or legal.
I need a VB Script that would scroll ID's from Consolidated Sheets Column A and almost 1000 entries. If list becomes blank at any point it should stop.
And output must be a pdf file containing All provided students in the "Consolidated" sheet with 10 outputs on each page.
I have data of 34 students for example but it could be around 1000 or more ...
Situation here is similar to this one
Actually "ID" is the main Identity.
I am using Vlookup for calling students data and picture.
Actually these are students cards. For printing purpose,
All I want is10 cards to be printed on single page.
As you can see that output is very small size.
Page size must be A4 or legal.
I need a VB Script that would scroll ID's from Consolidated Sheets Column A and almost 1000 entries. If list becomes blank at any point it should stop.
And output must be a pdf file containing All provided students in the "Consolidated" sheet with 10 outputs on each page.
I have data of 34 students for example but it could be around 1000 or more ...