VBA Auto selecting and calculating ranges
 

Hi,

I have a problem that I think can only be solved using VBA, correct m
if I'm wrong.

I have a spreadsheet that is used for resource estimations at work.

I have already managed to make the spreadsheet create a table based o
user defined preferences, but by using formulas instead of VBA.

I now need to select ranges and calculate them according on what is i
a specific box.

For example it plot a table for data input, with years and quarter
underneath. They carry on horizontally until the user defined en
date.

I need a way of calculating the totals for each year.

Is there any way of doing that? I.e. if the year is 2004, calculate th
sum of cells ... etc.

I have attached a file for reference.

Thanks

Attachment filename: test.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=41617
--
Message posted from http://www.ExcelForum.com