I want to populate a sales budget based on the selection of a start month. The start month can be from January to June. Is there an excel formula that can accomplish this? I have attached a sample file.
Thanks in advance
I want to populate a sales budget based on the selection of a start month. The start month can be from January to June. Is there an excel formula that can accomplish this? I have attached a sample file.
Thanks in advance
Last edited by Aland2929; 08-19-2010 at 01:46 AM.
Populate what with what? In the example, if the month selected is March, what value(s) need to be copied ... from where to where?
Regards
If March is selected the values from B12 to Y12 will commence from cell D5 (March).
If January is selected, the values from B12 to Y12 will commence from cell B5 (January).
The month selection determines the month when the budget starts from. Hope I have explained it OK?
Thank You.
One possibility
![]()
Please Login or Register to view this content.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
Thank you so much DonkeyOte. This works perfectly.
![]()
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks