I am trying to summarized several months of data from a credit card import into excel by vendor. Each month, the vendors may vary somewhat so there is no specific order of the vendors, month by month. How do I extract the information for each vendor, from each worksheet, to summarize it?

Thanks,

The how depends on your workbook structure. Attach one to a post with some representative data and we might be able to help you. You can do that via the paperclip symbol on the 'Go Advanced' tab at the bottom of this screen.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

I need to know how to summarize the data from a credit card statement by combining all months by vendor.

Attached Files

CC Charges.xlsx (28.2 KB, 10 views)

Your workbook layout, with separate sheets for different periods, makes summarizing anything more difficult than it need be. For summarizing, the data ought be on a single sheet to begin with.

Furthermore, since the vendor data includes apparently extraneous content, e.g.:
GOOGLE *ADWS6276120798 GOOGLE *Google Storage GOOGLE.GOOGLE *Music GOOGLE.
getting vendor aggregations isn't straight-forward, either.

Finally, your Summary sheet implies you want a separate entry for each transaction, in which case you may as well just put all the transactions on a single sheet and sort it by vendor or by date, according to what your requirements are at the time.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]