• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

I have a data validation list that creates report for 1000 people. How can I save each file as individual pdf with

can you provide a sample, not sure i understand the question, also as this is a free voluntary forum, i would allow more than 3 minutes for an answer - for me more like 24hours - but the mods my disagree with the timescale , but personally , i may read a question and not respond for a while.

infact it may take 5-10mins for me to get notified of a new thread in the forum, and then its when i get around to reading that email.
 
Sure thing. Sorry, just stressing because of the amount of work.

so basically I created individual reports using a data validation drop down list.
I need each drop down to save as individual pdf file.

Data validation list is in the student number
 

Attachments

  • FA9EB793-1DAF-44E6-B219-01509CE3139F.png
    FA9EB793-1DAF-44E6-B219-01509CE3139F.png
    798.8 KB · Views: 12
ETAF said:
can you provide a sample, not sure i understand the question, also as this is a free voluntary forum, i would allow more than 3 minutes for an answer - for me more like 24hours - but the mods my disagree with the timescale , but personally , i may read a question and not respond for a while.

infact it may take 5-10mins for me to get notified of a new thread in the forum, and then its when i get around to reading that email.
Click to expand...
Sure thing. Sorry, just stressing because of the amount of work.

so basically I created individual reports using a data validation drop down list.
I need each drop down to save as individual pdf file.

Data validation list is in the student number

Attachments
  • FA9EB793-1DAF-44E6-B219-01509CE3139F.png
 
ok, you will need VBA to cycle through all the dropdown list and save each one as a separate named PDF, VBA is not something i provide solutions on anymore, as i'm very out of date now
Sorry - hopefully another member will be able to assist
 
ETAF said:
ok, you will need VBA to cycle through all the dropdown list and save each one as a separate named PDF, VBA is not something i provide solutions on anymore, as i'm very out of date now
Sorry - hopefully another member will be able to assist
Click to expand...
Hopefully. Thanks
 
Creative carla
Where comes that J8-list?
... or have You really wrote there 1000 ids?
What should save by PDF?
... or only that cell's J8 value?
You should able to send a sample Excel-file and one expected PDF here.
 
vletm said:
Creative carla
Where comes that J8-list?
... or have You really wrote there 1000 ids?
What should save by PDF?
... or only that cell's J8 value?
You should able to send a sample Excel-file and one expected PDF here.
Click to expand...

J8 is unique identifier ID- I inserted as drop down list.
Each drop down should save as pdf
This is my excel file and pdf should look like this
 

Attachments

  • 65A79389-05D9-4C79-B422-53B6ADEF13AD.jpeg
    65A79389-05D9-4C79-B422-53B6ADEF13AD.jpeg
    272.7 KB · Views: 5
I did not write the IDs one by one.
I have one cell that contains the names and ID's
In the template ( photo shared) I use the data validation using ID to loop in data that comes along with the ID to one file.
 
Creative carla
Your how ...
... copy and paste Your used all data to my sent file and use it
Your ID > name ...
... did You mention it before?
... are names unique?
... it's possible do modify
Ps If You'll have 1000 people in Your list ... then those PDFs should save in own folder too.
Ps Your used pictures sizes were huge ... test this version.
 

Attachments

vletm said:
Creative carla
Your how ...
... copy and paste Your used all data to my sent file and use it
Your ID > name ...
... did You mention it before?
... are names unique?
... it's possible do modify
Ps If You'll have 1000 people in Your list ... then those PDFs should save in own folder too.
Ps Your used pictures sizes were huge ... test this version.
Click to expand...

Names are unique, yes...
and its good if it will be saved in a folder.
How?
 
You must log in or register to reply here.
Back
Top