Help Please - a simple question i believe!

[Muskins]

A bit of help for a 'novice' please - I am preparing a workbook that will track financials acrsoss 18 months for multiple workstreams. Currently only a couple of months have actuals the rest are still forecasts.
Please see below...

	Jun Jul Aug Sep Oct Nov Dec Total Act Act F'cast F'cast F'cast F'cast F'cast F'Cast <colgroup><col><col><col span="6"></colgroup><tbody> </tbody>

<colgroup><col><col><col span="6"></colgroup><tbody>
</tbody>

So when adding the August actuals i would like to update a cell in an 'input sheet' with the lastest month and would like this to change the column titles from forecast to actual - referencing and driven by the cell in the input sheet I will have just updated.

Is there a simple formula or function that will do this please?
Thanks in advance,
Jeremy

 

[jim may]

In your displayed Summary if your "Act" cell under Jun is the cell address is A2 -- what is in this cell? A value or a Formula
Same question as to the first F'cast under Aug - cell reference C2 - what does this cell contain? A value or a formula
Show for each, please.

 

[Muskins]

Hi Jim.
Thanks for your prompt response!

Currently the cells in row 2 are text ie "Act", but I was hoping to change from "F'cast" to "Act" by using a formula or function. This change would be triggered by updating the reference cell in my input sheet.

So when I come to add August actuals I change my reference cell in the input tab to Aug and that will drive the change in each of the workstream sheets. I hope that is clear?

thanks in advance
Jeremy

 

[jim may]

[FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]

Excel 2010
	A	B	C	D	E	F	G	H
1	Jun	Jul	Aug	Sep	Oct	Nov	Dec	Total
2	ACT	ACT	Fcast	Fcast	Fcast	Fcast	Fcast	Fcast
Sheet1

Cell Formulas
Range	Formula
A2	=IF(ISNUMBER(Sheet2!A2),"ACT","Fcast")

[/FONT]

Hi Jim.
Thanks for your prompt response!

Currently the cells in row 2 are text ie "Act", but I was hoping to change from "F'cast" to "Act" by using a formula or function. This change would be triggered by updating the reference cell in my input sheet.

So when I come to add August actuals I change my reference cell in the input tab to Aug and that will drive the change in each of the workstream sheets. I hope that is clear?

thanks in advance
Jeremy

 

[jim may]

My post went out prematurly. What I was tryig to establish was If in uour Input Sheet you have a numeric in the August Column, row 2
then on your summary sheet row 2 would change from Fcast to Act...