M
Matt
I have monthly expense spreadsheets that are ordered by date with a vendor name in the first line item along with item purchased and amount and on the same line as the vendor name is an order total for that order. I may purchase from the same vendor several times per month and over several months. I am looking for a way to grab the vendor name from each order and them combine all of the same vendor totals into a grand total on another spreadsheet in the same workbook. This sheet would be able to determine if the vendor name is old or new and if it is new it would add another entry for that vendor and start a grand total for that vendor as well. Is this possible? Here is an idea of the layout of the monthly sheets
Date Vendor Item $/item Qty. Item tot Ven. Tot
1/1/4 me A 1.00 1 $1.00 $5.0
B 2.00 2 $4.0
1/1/5 you C 2.50 2 $5.00 $10.0
D 1.00 5 $5.0
The Grand Total sheet would contain an entry for each vendor with the totals for that vendor from all sheets. As you can see the data would be in the same columns for each month and the format would be the same
Date Vendor Item $/item Qty. Item tot Ven. Tot
1/1/4 me A 1.00 1 $1.00 $5.0
B 2.00 2 $4.0
1/1/5 you C 2.50 2 $5.00 $10.0
D 1.00 5 $5.0
The Grand Total sheet would contain an entry for each vendor with the totals for that vendor from all sheets. As you can see the data would be in the same columns for each month and the format would be the same