Super useful! I use this code to create large number of personal reports for different users of one of our farm management programmes from an excel file. I used to do this via MailMerge, but wanted to create a version that allows for inclusion of charts that display the user's performance relative to the the larger population or other benchmark values. Getting charts into MailMerge is not impossible, but has severe limitations on the type of charts and the number of series in any given chart (only a single series is possible to my knowledge). Having a couple of charts in the Template and the Active sheet works a treat as long as automatic calculation is switched on. Thank you so much, discovering this video really made my day :)
I've done one with Google doc as a template already. The problem is there is execution time limit, so if you need to create a large number you will probably run out of time.
@@ExcelGoogleSheets if we stay under, let's say 30, do you think sheets would time out in that case? BTW, your videos have helped my spreadsheet knowledge grow exponentially. I wish these videos were around when I first started learning excel, we'll say a few years ago. Thanks again.
Thank you so much for this great tutorial! I am trying to apply this to a pivot table to generate a purchase order by customer (each customer has at least three purchased itens) on individual PDFs. Printing it separately is not an issue since I can set the customer filed on the pivot table as a page break. The challenge is generating and saving the pds. Looking forward to hearing from you on this :)
Google Sheets version would likely be very slow, so with limited execution times you probably wouldn't be able to make a large number of PDFs without doing some sort of batch processing.
Great code! super helpful... Was wondering how I could modify it to have all of the pdfs into one doc instead of separate ones. I am thinking that I need to move the 'next r' location?
Thanks for the video. When i'm running through the code step by step using F8 (as shown around the 21 minute mark), the code isn't making any changes to my document. I've triple checked the code and it matches what's in the video perfectly, down to the last comma. Is there any way to troubleshoot this?
Excellent but you forgot to disable screen updating to stop annoying blinking of the screen specially when the list is long. One more thing, you could take this project one step further by creating templates word document and use them. Thank you
This is AWESOME... I love your videos... I do have one question for this one though. If we were to add more customers to that list and click create PDF would it overwrite all the existing data or continue on with just he new data? Maybe add a check to see if file already exists?
thanks , its really help, but how / what code to add if we want to read the next column, in this example here, we replace in A column only..(active sheet)
Fantastic work, thank you for taking the time to do the video. I'm having a problem with it. For my original data set it works fine. I essentially added more to the list and it stops at the original number and gives me a file not saved error. When I hit debug, it said the issue is in the activetab export section. Would you be willing to help me with this please?
I should clarify that it will make the PDFs for the original ones but not the new stuff. And if I try to remove the old and put the new in its spot, it still won't work.
Hi sir Thank you so much & it worked well. But it would be of great help if we have code to directly send an email attaching those pdfs via outlook. Please would you mind updating that
hi nice video , just wanted to check one thing can we disable the right click or editing the pdf file created , i just want user should not able to edit the pdf file if any pointers please help
@@ExcelGoogleSheets Teacher... My daughter is a Personal Chef in Palm Springs and I set her up with an Invoice based on your Invoice and Row Videos. However, she asked me for a Modification which I thought was really pretty cool. I have been working on it and I am now Stumped. Below the the area where Description, Qty, Amount and Total is I set up an Identical Description, Qty, Amount and Total area. The Original area she uses for Taxable Items and the New Area is for Non-taxable Items. I have it setup and it works, until, Rows are Added or Deleted. What happens is when the Array kicks in the Formula/s is unable to Communicate between the Taxable and Non-taxable Formulas properly, thus the Arithmetic in the Subtotal, Total Field at the end are no longer Accurate and that's where I can't seem to get past. Anyway, while working on the Problem it came to me that it would make a Great Video for you to show TH-camrs how you would Solve this Puzzel!!! BTW... I won't go into it now, but there are a couple of other things that would make interesting Video/s if you would care to hear them. If you would like to call, I left my Number at your Office.
![ประสบการณ์ จ้าง Developer ที่ผมจะไม่มีวันลืม [ภาค1]](http://i.ytimg.com/vi/bzivN4KDg-k/mqdefault.jpg)
the best excel teacher i found after a long time
Super useful! I use this code to create large number of personal reports for different users of one of our farm management programmes from an excel file. I used to do this via MailMerge, but wanted to create a version that allows for inclusion of charts that display the user's performance relative to the the larger population or other benchmark values. Getting charts into MailMerge is not impossible, but has severe limitations on the type of charts and the number of series in any given chart (only a single series is possible to my knowledge). Having a couple of charts in the Template and the Active sheet works a treat as long as automatic calculation is switched on. Thank you so much, discovering this video really made my day :)
Great work. Do you have a solution for google sheets too?
I've done one with Google doc as a template already. The problem is there is execution time limit, so if you need to create a large number you will probably run out of time.
@@ExcelGoogleSheets if we stay under, let's say 30, do you think sheets would time out in that case?
BTW, your videos have helped my spreadsheet knowledge grow exponentially. I wish these videos were around when I first started learning excel, we'll say a few years ago. Thanks again.
Thank you so much for this great tutorial! I am trying to apply this to a pivot table to generate a purchase order by customer (each customer has at least three purchased itens) on individual PDFs. Printing it separately is not an issue since I can set the customer filed on the pivot table as a page break. The challenge is generating and saving the pds. Looking forward to hearing from you on this :)
WOW, it 's awesome~ I look forward the Google Spreadsheets version
Google Sheets version would likely be very slow, so with limited execution times you probably wouldn't be able to make a large number of PDFs without doing some sort of batch processing.
Great code! super helpful... Was wondering how I could modify it to have all of the pdfs into one doc instead of separate ones. I am thinking that I need to move the 'next r' location?
Thanks for the video. When i'm running through the code step by step using F8 (as shown around the 21 minute mark), the code isn't making any changes to my document. I've triple checked the code and it matches what's in the video perfectly, down to the last comma.
Is there any way to troubleshoot this?
Excellent but you forgot to disable screen updating to stop annoying blinking of the screen specially when the list is long. One more thing, you could take this project one step further by creating templates word document and use them. Thank you
Agreed on screen updating.
Hi, Request to upload VBA code here in the Comments.thanks
Great video, very helpful
can you tell me.. how can we create a password protected pdf with different passwords.. like the name of pdf.. thank you
Thanks!
Thank You!
Does this work if the cell value is in images?
This is AWESOME... I love your videos... I do have one question for this one though. If we were to add more customers to that list and click create PDF would it overwrite all the existing data or continue on with just he new data? Maybe add a check to see if file already exists?
With current setup it will recreate all. You could add handling to check if the file exists.
strFileExists = Dir("C:\Users\myfile.xlsx")
If strFileExists = "" Then
'code to create the file
End If
thanks , its really help, but how / what code to add if we want to read the next column, in this example here, we replace in A column only..(active sheet)
Fantastic work, thank you for taking the time to do the video. I'm having a problem with it. For my original data set it works fine. I essentially added more to the list and it stops at the original number and gives me a file not saved error. When I hit debug, it said the issue is in the activetab export section. Would you be willing to help me with this please?
Did you select the right data first?
@@ExcelGoogleSheets I'm not sure...on the active tab it fills in the information, it just won't create a pdf and save it.
I should clarify that it will make the PDFs for the original ones but not the new stuff. And if I try to remove the old and put the new in its spot, it still won't work.
Hi sir
Thank you so much & it worked well. But it would be of great help if we have code to directly send an email attaching those pdfs via outlook. Please would you mind updating that
Excellent tutorial 👏👏👏
If possible generate a Word document for a template un Word 🙏🙏
If you don't need PDF, then just regular mail merge should be able to do that without macros if I'm not mistaken.
hi nice video , just wanted to check one thing can we disable the right click or editing the pdf file created , i just want user should not able to edit the pdf file if any pointers please help
Thaks, very useful.
:)
Why are curly brackets appearing in the pdf along with the cell value?
Geveme template please, cogratulations
Teacher... Any Plans in the Works to Modify your Invoice Template?
not really. what you mean by Modify?
@@ExcelGoogleSheets
Teacher... My daughter is a Personal Chef in Palm Springs and I set her up with an Invoice based on your Invoice and Row Videos. However, she asked me for a Modification which I thought was really pretty cool. I have been working on it and I am now Stumped. Below the the area where Description, Qty, Amount and Total is I set up an Identical Description, Qty, Amount and Total area. The Original area she uses for Taxable Items and the New Area is for Non-taxable Items. I have it setup and it works, until, Rows are Added or Deleted. What happens is when the Array kicks in the Formula/s is unable to Communicate between the Taxable and Non-taxable Formulas properly, thus the Arithmetic in the Subtotal, Total Field at the end are no longer Accurate and that's where I can't seem to get past. Anyway, while working on the Problem it came to me that it would make a Great Video for you to show TH-camrs how you would Solve this Puzzel!!! BTW... I won't go into it now, but there are a couple of other things that would make interesting Video/s if you would care to hear them. If you would like to call, I left my Number at your Office.
how if we want to add chart ,graph radar on that code bro. ?
What if on same I'd we are having multiple accounts and we want account balance details for all accounts in same pdf
Hi can you create a video for merging excel data into word document using vba?
Why do you need VBA? Regular mail merge doesn't do what you need?
Thank you replying. I did created myself. I needed that for my work. I used that a lot. It is now Saving my time and clicking
DEAR SIR, HOW TO USE FILTER FUNCTION WITH ARRAYFORMULA IN GOOGLE SHEET ?? IS IT POSSIBLE OR NOT???
Not at the moment.
@@ExcelGoogleSheets t
Thank 🙏🙏you Sir.
Can you share the file it takes a long time when I make one like this Can you share the file please
text