Excel - Print to pdf after updating cell values based on different cell value.

Occasional Visitor

Hi members,

 

I have an excel sheet for invoicing with linking to different sheet which is having data for all the invoices raised. Currently, I feed data in the databases sheet and then manually change invoice number in invoice sheet for printing one by one.

 

How can I automate the process of changing invoice number between a specific range from database sheet and then print to pdf automatically.

 

Thanks in advance for you support.

1 Reply
This board is for things related to Microsoft Learn and Microsoft Certifications. I would recommend reaching out on the Microsoft Excel Community https://techcommunity.microsoft.com/t5/excel/ct-p/Excel_Cat