Help creating Macro - VBA Code

Question

I need help creating a Macro to print a single document with multiple pages. I have a one Sheet and the macro needs to change one cell (B2) each time it loops. I've tried researching but I have not found any examples of the Macro compiling the pages into one document. Is this possible?

Answer 1

Thanks Jeovany. To give you a little more detail, I have a Cost Centre expense report in excel where there is a cell at the top where I can change the cost centre number and the figures in the report update accordingly. Instead of having 100 tabs for each cost centre and printing them all to one PDF document, I wondered if there is a way to create a macro that changes the cost centre number at the top of the report each time and prints one PDF with all the cost centre reports in? All the examples that I can find online prints a PDF document after every cost centre which I don't want.

Answer 2

I need help creating a Macro to print a single document with multiple pages. I have a one Sheet and the macro needs to change one cell (B2) each time it loops. I've tried researching but I have not found any examples of the Macro compiling the pages into one document. Is this possible?

Hi Jordan

Welcome to the MS Excel forum

In order to provide you with a correct answer we need to know more details about your scenario and goals

From your description, I wonder if this is what you are looking for

https://youtu.be/2K1wijqFVDw

https://youtu.be/T5dRVGbn7-Q

I hope this helps you and gives a solution to your problem

Do let me know if you need more help

Regards

Jeovany

Answer 3

Single document with multiple pages?? Sounds you're asking for a Word macro?

Andreas.