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
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