Instead of subtotals, you could use a pivot table to summarize the data.
Jon Peltier has instructions and links on his web site:
http://www.peltiertech.com/Excel/Pivots/pivotstart.htm
Add Vendor number and Vendor name to the row area, and put the dollar
field into the data area, where it will become Sum of Dollars.
TJAC wrote:
I have a spreadsheet and have used the subtotal (Data -- Subtotals). I have
chosen to subtotal dollar amount for a particular vendor number, however the
names of the vendors does not appear then. How can I get the name of the
vendor to appear as well?
Thanks,
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html