VBA CODE TO INCREMENT FORMULAS

[thalenz93]

Good day Mam/Sir,
I just want to inquire if there is any VBA CODE for the following Case:

I have a format in Sheet 1 which requires 2 cells lets say A1 and B1 to be changed every after printing. The source formula from the cell A1 and B1 came from Sheet 2.
I need to have a faster way for continuous printing without a need of entering the data one by one.

Thanks and hoping to hear from you soon.

[#2]

@thalenz93 

With your permission, if I may recommend, add a file (without sensitive data) and use this file to describe your problem step by step, or add photos with the appropriate description.  

You'll get a quicker and more accurate answer, and those who want to help don't have to invest time guessing the problem.

Always inform about your Excel version, operating system, storage medium/hard drive, OneDrive, Sharepoint, etc.).

Don't forget no one in this forum can see what you see.

In this link you will find some more information about it:

Welcome to your Excel discussion space!

Thank you for your understanding and patience

NikolinoDE

I know I don't know anything (Socrates)