What Formula can move the cell in the formula to the right?

[gotiono]

Hello,

I'm looking for a function or button that will allow me to update the cell # to the right in a formula every time I press the button or run the macro or function.

='C:\Users\312583\Desktop\[INVR.xlsx]RI'!$Q$8 (this month) -----> ='C:\Users\312583\Desktop\[INVR.xlsx]RI'!$R$8 (next month) -----> ='C:\Users\312583\Desktop\[INVR.xlsx]RI'!$S$8

[Keebellah]

Hi, welcoem to the forum.
How's your own VBA knowledge?
If you know how to work with macros and edit the you can record a macro while you do the steps manually. Stop the recorder and the see how it works and edit it accordingly
This for starters

[NARAYANK991]

Hi ,

If you want a button to be clicked , then to respond to the button click , you will need a VBA macro.

See the attached file. The code is :

Please Login or Register  to view this content.

Each time you click the button , the formula in cell D6 will change.

Narayan