Hi Guys,
I've got excel 2010. Here's what I'm after.
I'm trying to simplify a spreadsheet of startup costs. Basically, I'm looking to analyze the startup expenses from a number of different perspectives. Each cost has a few columns: Account code, description, price, vendor, type of asset, and depreciation method to be used. Here's some of the parameters I would like to be able to set, but I have no idea where to begin:
User Inputs:
Let's say there are 150 rows of startup costs, what would be the best way to configure a few of the user inputs, and have it update a completely different table with the information? Say for instance, I wanted to narrow the list down to all fixed assets, over $500, with account code 300. How would I have excel run the data, and then save the output (like say the sum of the prices) to a new table - and then (and here's the big part) NOT overwrite the data already in the table....just add a new set of data based on what was run?
Thanks for any help! This one has me stumped!!!
I've got excel 2010. Here's what I'm after.
I'm trying to simplify a spreadsheet of startup costs. Basically, I'm looking to analyze the startup expenses from a number of different perspectives. Each cost has a few columns: Account code, description, price, vendor, type of asset, and depreciation method to be used. Here's some of the parameters I would like to be able to set, but I have no idea where to begin:
User Inputs:
- Cost thresholds
- Which categories are included in the calculation
- Which types are included in the calculation
Let's say there are 150 rows of startup costs, what would be the best way to configure a few of the user inputs, and have it update a completely different table with the information? Say for instance, I wanted to narrow the list down to all fixed assets, over $500, with account code 300. How would I have excel run the data, and then save the output (like say the sum of the prices) to a new table - and then (and here's the big part) NOT overwrite the data already in the table....just add a new set of data based on what was run?
Thanks for any help! This one has me stumped!!!