This is damm clever. So I have a spreadsheet with a month on each sheet. I created a summary sheet, and wanted to have a formula on the summary sheet that was clever enough to look at the column heading and reference the related sheet. I found this website: http://www.mrexcel.com/archive/Dates/23944.html
Summary Sheet
|
|
C |
|
2 |
01/01/2011 |
|
3 |
=SUM(INDIRECT(TEXT(C$2,”mmm”)&”!$C$3:$C$5″)) |
Jan Sheet
|
|
C |
|
3 |
500 |
|
4 |
500 |
|
5 |
600 |
How wicked it that! Well it made my day anyway
flaphead.com 