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.
To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.
With the internet and the ease of information transference, many professional jobs can be done anywhere today. Why should it make a difference whether an x-ray is read in India or the United States as long as the radiologist is qualified? Outso…