jcountry22
New Member
- Joined
- Aug 15, 2014
- Messages
- 36
I'm trying to create a reforecast model that will automatically update values based on the month that appears in a drop-down menu.
I have the drop down menu created -- it's just a matter of getting the formula to pull the correct value.
SHEET 1 has the months in column C through N (row 3)
Account Numbers start in cell A5
the formula's I need will be on my "SUMMARY' sheet that has the drop-down menu. SHEET 1 contains all my data that the formula(s) should read from.
the formula i need to read the account # listed on the SUMMARY sheet, to find it on SHEET 1 and pull the data set that coincides with the selected month from the drop-down menu (on the SUMMARY sheet). The # it pulls should come from SHEET 1 from the designate month.
Any help is much appreciated. If more info/details are needed let me know.
I have the drop down menu created -- it's just a matter of getting the formula to pull the correct value.
SHEET 1 has the months in column C through N (row 3)
Account Numbers start in cell A5
the formula's I need will be on my "SUMMARY' sheet that has the drop-down menu. SHEET 1 contains all my data that the formula(s) should read from.
the formula i need to read the account # listed on the SUMMARY sheet, to find it on SHEET 1 and pull the data set that coincides with the selected month from the drop-down menu (on the SUMMARY sheet). The # it pulls should come from SHEET 1 from the designate month.
Any help is much appreciated. If more info/details are needed let me know.