excel macro to change a cell formula Closed

Question

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

Configuration: Windows XP / Internet Explorer 7.0

rizvisa1 · Answer

Before clicking on "button", what would be in between cells C80 - C95

smiffy · Answer

Cell references for the other day's figures.

rizvisa1 · Answer

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

Excel macro to change a cell formula

3 responses

Similar discussions

Subscribe To Our Newsletter!