![]() |
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 |
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