Hi all,

I have 2 spreadsheets. 1 of them (called "broker confirm") gives me
information on peoples stocks that have been sold or bought. This
information changes daily. For example, it has a column that tells me
"Shares sold", "Shares Bought" , "Shares Issued" and one field that I
always have to delete called "Journal" that I have to take out before I
can get the sum. The way the broker sends me this file is sorted by
name of the shareholder. So there will be a line of sold, then bought,
then another sold ... I need them sorted by "sold", "bought" and
"issued". The other spreadsheet (called "Proof") needs the sum of just
sold shares, bought shares ... etc.

So, is there a way to make it sort the information by sold, bought ...
etc, get the sum of the individual types and add them to the "proof"
spreadsheet?

Ive added a screencap of the "broker confirm" for better understanding.


Thanks


---
Message posted from http://www.ExcelForum.com/