Yes it can be done just you need to give more detail.
1). How many Vendor worksheets or is it a Sheet per month.
2). Is it for a calendar year
3). Do you want it in the same sheet or a summary sheet
4). What columns have the dates and which ones have the Vendors
Odds are it will be a SumProduct function. The attached link should
help
http://www.xldynamic.com/source/xld.SUMPRODUCT.html
VBA Noob
--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile:
http://www.excelforum.com/member.php...o&userid=33833
View this thread:
http://www.excelforum.com/showthread...hreadid=562572