Austin, TX

Help with Excel?

I have a spreadsheet for an annual budget with the monthly detail data on one worksheet (the tab is labeled Monthly Detail) and I summarize the Current Month and Year to Date data on a different worksheet (the tab is labeled 2014 Summary).

I would like to find a way do pull the "current" month's data from the current month cells on the Monthly Detail worksheet and put that data in the "CURRENT MONTH" cells in the 2014 Summary worksheet. I can't seem to figure out how to do this for more than 2 months. (Yup! I got January and February to work with an IF/Then/Else...but since it peters out after a TRUE/FALSE/THEN I'm stuck!)

So, each month's detailed data is located in worksheet "Monthly Detail" cells (Jan) B47, (Feb) D47, (Mar) F47, (Apr) H47...and so on...through (Dec) X47.

On the 2014 Summary page, in cell B49, I want to (A) determine the current month, then (B) pull from the appropriate cell of the "Monthly Detail" worksheet, the correct data, and put it that correct data in cell B49 on the 2014 Summary worksheet.

FYI: On the 2014 Summary worksheet, in cell A2, I have =MONTH(TODAY()) which returns a value of 1 for Jan, 2 for Feb, 3 for Mar and so on.....

That said,

So for January 2014, I want a formula in B49(of the 2014 Summary worksheet) that goes to the worksheet, "Monthly Detail", and pulls only January data and puts it in B49. In February, I want to go to "Monthly Detail" and pull February data and put it in B49 since that will be the 'current' month. Then in March I wan to pull March data and so on through December of 2014 cause then someone else will have to figure this out!

Right now I can't figure out how to code a formula on the 2014 Summary worksheet to pull the correct (Monthly Detail) MONTHLY cells into the correct CURRENT MONTH cells on the 2014 Summary worksheet. Heck, I don't even know if I'm doing this the right way!

Any help would be gratefully appreciated! Just remember 2 things, first I'm the dumbest coder ever! and second, don't forget number one!

Thanks (in advance!)

Can someone help me understand why the temperature was 22F when Felix jumped yesterday from over 128 thousand feet up? I would have thought it would have been in the minus 70F range...

I'm trying to find a good NIV84 bible that I can install on my windows 7 pc but don't seem to be having much luck. I wouldn't even mind coping it disk-by-disk, if necessary. I'm not looking for an audio bible, have plenty of those, just a good text search-able, download-able NIV84 bible.

Thanks in advance to all those who help!

Why would anyone feel the need to attack or belittle anyone trying to help them see the light and perhaps discover the Good News of Jesus Christ?