This might be an impossible task:
I have a workbook with ~50 worksheets and then a summary worksheet. Each worksheet has a list of codes in column C and a dollar amount associated with it in column E. My summary sheet has codes listed in column C and then the combined total for that code from...
I have a 2010 spreadsheet that uses VLOOKUP to pull $ amounts in multiple catagories. Each catagory is a column. Each row is the store being charged. The end of each row is the total cost charged to the store and the end of each column is an average cost of that catagory.
I have used the...
I have a sheet of vendors and their contact info. I would like people in my department who have access to this sheet to be able to use a dropdown list to View All Vendors or View Vendors by Field. So far I have successfully used the different vendor field selections in a data validation list...