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

[neelkaushik]

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.

[#2]

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