VBA Auto selecting and calculating ranges

A

arunsharm82

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Emailing a sheet from a workbook with VBA 0
VBA help with selecting multiple data ranges 1
Excel formula help for calculating freight. 2
Calculate Total Hours when Overlapping Occurs 0
VBA - function doesn't calculate unless clicked on 2
use ComboBox value to select range and then use selected range tocreate a chart 3
Create Table with the range of selected cells 7
Slicers and Calculated Items in Pivot Table 2

Top