leftkick
02-20-2010, 07:23 PM
Hey all.
My first post here! :)
I have a spreadsheet with about 10 tabs. I'm trying to create something similar to a calculator of sorts. I think this might be a macro/vba task, but what I am trying to do is this:
I have my inputs and it will, according to the numeric assignments, give me an output of ranges. The time frame for this spreadsheet is something like over the next 75 years. I want it to automatically recalculate itself every 5 years so the numbers are more closely fit/statistically accurate.
Should I attempt to write some sort of macro/vba to recalculate itself every 5 years like: calculate for years 1 - 5, recalculate years 6 - 11, recalculate years 12 - 17, etc...
Any suggestions or help would be greatly appreciated. Thanks so much and I hope I made some sense!!
My first post here! :)
I have a spreadsheet with about 10 tabs. I'm trying to create something similar to a calculator of sorts. I think this might be a macro/vba task, but what I am trying to do is this:
I have my inputs and it will, according to the numeric assignments, give me an output of ranges. The time frame for this spreadsheet is something like over the next 75 years. I want it to automatically recalculate itself every 5 years so the numbers are more closely fit/statistically accurate.
Should I attempt to write some sort of macro/vba to recalculate itself every 5 years like: calculate for years 1 - 5, recalculate years 6 - 11, recalculate years 12 - 17, etc...
Any suggestions or help would be greatly appreciated. Thanks so much and I hope I made some sense!!