Help with automating my totals

[David Evans]

Okay, I'm clueless when it comes to excel macros

What I've got, is a table of data that can have an undified amount o
columns (can be from 1 column to 200 say)

It can also have a large amount of rows of Data

What I need is a macro that will give the totals for each row of data
and with that data, be able to automaticall generate a pie chart (i'v
got all the pie macros sorted).

Attached is an .xls of the basic stuff I need

Thanks in advanc

Attachment filename: simple.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=62934

 

[Earl Kiosterud]

David,

You may not need a macro -- just some formulas, or maybe a pivot table.
Your attatchment didn't get posted -- attachments are not allowed in these
groups. Describe your sheet and what you want. Be specific. Give
examples. We can help.

 

[W. D. Allen Sr.]

Chip Pearson can help you. Find him at: http://www.cpearson.com/excel.htm

WDA

end