Excel macro to change a cell formula

[Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hi,
I have three spreadsheets, one in which I enter data on a daily basis. The second collates this information by using referencing directly from the first spreadsheet. I want the third to display a two week snapshot of the second spreadsheet. I wish to have a button on the third page that, when pressed, shows the next fortnight.

the formula for a cell is
='Q:\Admin Support Team\Post out\[Post-Out Letter Tracking Matrix YEAR2010.xls]Summary'!C79

and once the button is pressed once, i would like it to be
='Q:\Admin Support Team\Post out\[Post-Out Letter Tracking Matrix YEAR2010.xls]Summary'!C95

So All i need to do is increment the cell reference by 16 each time.

Any help would be much appreciated

3 replies

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Before clicking on "button", what would be in between cells C80 - C95
Cell references for the other day's figures.
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
I am finding your requirement bit confusing. Could you possible put up a sample file . The confusion is arising from the fact why this Summary'!C79 and why it will become Summary'!C95, Since you said that before pressing button there is data underneath C79 , so the question is how one can say it is time to move to 95 or further down 16 rows etc. If you can put up a sample file at some share location and post back link here, it would be easier to see the flow. https://authentification.site is one of many share sites