Sum across a variable range

[alloutdoors681]

I have (and have had for some time) a dilemma that I cannot figure out. I am not that good with programming languages, which seems to exacerbate my problems.

I have a spreadsheet that contains the landcover habitat descriptions for numerous properties and different ownerships. For example, Ranch X has Y acres of grass that is privately owned and Z acres of grass that is publicly owned. So there are multiple entries for each Ranch.

I am trying to find a macro that will sum the acreages for each ranch (there are about 1,000 total ranches), but the range is variable for each ranch. For example Ranch X has 4 habitat types and 2 ownership values, but Ranch Y has 10 habitat types and 3 ownership values.

Does anyone know the best way to go about this? Right now I have to create a sum for each individual ranch and I would like something that was a little less time consuming.

Any help is greatly appreciated.

Ryan

[NBVC]

Have you thought about/read up on/tried Pivot Tables?

http://peltiertech.com/Excel/Pivots/pivotstart.htm

http://datapigtechnologies.com/ExcelMain.htm

http://www.ozgrid.com/Excel/PivotTab...CreatePiv1.htm

[6StringJazzer]

You probably don't need a macro for this. Maybe a pivot table would work, maybe formulas. But it's impossible to tell without seeing what data you have and how it's laid out. Can you attach the workbook without disclosing private data?

[alloutdoors681]

The Pivot Table works better than going through and doing everything by hand, but I wanted to try the Macro route so I could end up with the same output as another table so my tables would match and it would be a lot less busy work than the Pivot Table route.

For now I will continue with the busy work. Thanks for the help.

[alloutdoors681]

I can tell it's been a long day.

By simply choosing the habitat types to include in the Pivot Table prior to starting the Pivot Table I got it to work just the way that I wanted it without all of the busy work.