"Michele" wrote:

i have a worksheet seperated by columns:

DATE / VENDOR / DESCRIPTION / FILE / MONTH / AMOUNT

i hope i explain this properly. i would like to cosolidate vendors. if there
is a vendor that shows up multiple times than i would like it to cosolidate
the name and just show me a total for that vendor for each month. i have at
least 30 vendors and over 1000 row of data. is this possible.