Replace column id with value in AD1

[Topperfox]

I have an Excel 2007 workbook with 12 spreadsheets Jan-Dec and a Budget sheet. The Budget worksheet has Columns C-N for January-December.

I want to put the correct column in Budget for each of the sheets Jan-Dec in cell AD1. So, Jan sheet's AD1 would have "C", Feb sheet's AD1 would have "D", Mar sheet's AD1 would have "E"...

All the Jan-Dec sheets are exactly the same other than the column they look at in the Budget sheet.

Budget!$[Get value from AD1 in this sheet]1 would save me hours of work because all the sheets would be exactly the same except for the value in AD1.

Thanks

 

[Special-K99]

Assuming your 12 sheets are named Jan Feb Mar etc

Maybe

in Budget sheet column C
=INDIRECT(TEXT(COLUMN()-2,"mmm")&"!$AD$1")

and copy across as necessary

 

[Topperfox]

My first time using Rapidshare, I hope this works:

Three screenshots should show what I am doing. At the present time I am using Ctrl-Find-Replace to change the columns. But... it is not 100% accurate and any mistake means an unpaid bill or a bill I did not budget for.

B9 on Jan sheet:
http://rapidshare.com/files/414331883/SampleBudgetJanSheet.PNG

B9 on February sheet:
http://rapidshare.com/files/414331884/SampleBudgetFebSheet.PNG

Budget sheet showing where the Monthly sheets are looking at:
http://rapidshare.com/files/414331885/SampleBudgetSheet.PNG

Thank you

 

[Topperfox]

My apologies, apparently the links I copied & pasted to each screenshot only direct you to advertising.

Topperfox