Michele

Posts: n/a

Consolidate

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.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to consolidate data from multiple worksheets.	SAR	Excel Worksheet Functions	0	August 28th 05 12:56 PM
Consolidate data from several workbooks	kwatch	Excel Worksheet Functions	0	April 14th 05 09:58 PM
Consolidate data from several worksheets via pivot table	mthatt	Excel Worksheet Functions	0	March 23rd 05 06:51 PM
Consolidate sheets	Manos	Excel Worksheet Functions	2	February 14th 05 03:12 PM
Consolidate list from multiple worksheets	VT	Excel Worksheet Functions	0	November 24th 04 04:51 PM

All times are GMT +1. The time now is 07:29 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us