I have a spreadsheet with a list of years as column headers, beginning with this year.
2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 etc.
Below each year I have a figure in dollars of what funds could be raised for that particular year (a special church building fundraiser). The data for each year is calculated from other budget data.
The main point is that there is no way the church can run a fundraiser every year, so I want to program the spreadsheet to be able to respond to a certain number of criteria:
A) How many years from now will you start your first cycle of fundraising?
B) How many years will each cycle last?
C) How many years break will you take before starting the next cycle?
D) How many cycles of fundraising overall will you have?
I want to have a way for these user-inputted criteria above to be accounted for. So, if the answers to questions A-D above are:
A) Start in 1 year
B) 3 year cycle
C) 1 year break
D) 2 cycles total
... then I want to see fundraising figures for only the bold, starred years below:
2007 *2008 *2009 *2010 2011 *2012 *2013 *2014 2015 2016
Anybody have a suggestion for a strategy and any particular helpful functions for tackling this?
I have been trying different VBA functions, but have gotten lost. I am pretty new to this but can learn quickly if you give me a suggestion to go research. Thanks!
Bookmarks