Complex Excel (Somewhat)
Posted on 2014-04-17
I recently created an excel spreadsheet with a list of vendors and payments I have made.
What I am looking for do is bring create a drop down list and it will bring all those vendors into one area and give me a total cost.
A B C D E F
1 Location Type Month Year Amount Vendor
2 New York Data 11 2013 100.00 Time Warner
3 Ohio Voice 11 2013 55.00 Verizon
4 Oregon Data 12 2013 65.00 AT&T
5 New York Data 1 2014 101.50 Time Warner
6 New York Voice 1 2014 55.00 Verizon
So If I want to create a drop down that if I wanted to select New York it will bring the entire row (1 and 5) and add the amount together and filter them. Same with Month or Year, I want it so it adds it up totally. Also same with Vendor, if I choose a vendor I want it all to show up and break it down. I know I can use the filter option but I am looking out of that so an drop down can happen and also it be nice to have a pie chart added as well would be a plus.