Needs some VBA help

[Maxim_G]

Hey guys, I'm having a bit of a problem since I'm a VB noobie.

I have several raws for different categories (lets say 4 categories:
1- Capex
2 - Opex
3 - Tax
4 - Dep, for example)

In each category, I have some raws for some sub-categories (lets say 3 for each:
1.1- machinery, 1.2-computers , 1.3-deliniation, for example
2.1 , 2.2 , 2.3
3.1 , 3.2 , 3.3
4.1 , 4.2 , 4.3)

and I have some raws for sub-sub-categories (lets say 2 for each:
1.1.1- cars, 1.1.2-tank & 1.2.1- PC , 1.2.2- laptop & 1.3.1-drill , 1.3.2-seismic, for example
2.1.1 , 2.1.2 & 2.2.1 , 2.2.2 & 2.3.1 , 2.3.2
3.1.1 , 3.1.2 & 3.2.1 , 3.2.2 & 3.3.1 , 3.3.2
4.1.1 , 4.1.2 & 4.2.1 , 4.2.2 & 4.3.1 , 4.3.2)

I want to be able to Plot each category vs. time (e.g., CAPEX vs. Yr), each sub-category vs. time (Machinery vs. Yr) and each sub-sub-category vs. time (e.g., cars vs. Yr)

So, I would like to

1- add checkboxes for each category and sub-category and sub-sub-category and assigne them to a macro
2- whenever the checkbox is checked, the data of the range should be selected and stored in a range variable,

AND

the values of the selected range must added to the values of another defined variable (e.g., sum) and
3- the graphs can be ploted.

Is this possible?

Thanks in advance

 

[CharlesChuckieCharles]

after 27 views with no replys I think you may need to re-write for people who aren't exposed to the data you are trying to deal with... ( as in where's the Year data??) maybe use one of excel loading tools or do a mock up of your intended end result