ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   summing up (https://www.excelbanter.com/charts-charting-excel/109259-summing-up.html)

ASU

summing up
 
I have a spreadsheet with data that I wish to sum up just two columns (A and
K cols). I need to filter column "A"( that column list names of items which
can be repeated in any order), and totals in column "K".
I'm looking for a vb code that will insert a summing sheet with the list of
items in one column and there totals in another, and then product a bar chart.
Is tht possible?
--
ASU

Bernard Liengme

summing up
 
Have you thought of a pivot table? Try Help and then come back with more
questions.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"ASU" wrote in message
...
I have a spreadsheet with data that I wish to sum up just two columns (A
and
K cols). I need to filter column "A"( that column list names of items
which
can be repeated in any order), and totals in column "K".
I'm looking for a vb code that will insert a summing sheet with the list
of
items in one column and there totals in another, and then product a bar
chart.
Is tht possible?
--
ASU





All times are GMT +1. The time now is 02:14 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com