Question on manipulating data in one table, that references data from another
Hello,
At the car dealership that I work at, we have an 'master' spreadsheet to track data for our vehicles. Different departments use this spreadsheet for different reasons. For example, the one employee may use it to check on the status of titles, another may use it to give pricing to a potential customer. Because of this, the spreadsheet contains many a lot of cells with data that pertains to many people, with some overlap.
I have been trying to check our pricing to make sure it is in line with our competitors. For that, I would need a handful of information from this 'master' spreadsheet to check the price of these vehicles. I need a separate page, on the same doc, that will do the following:
1. Sort a particular feature of each car model. For example, to sort by year, current price, mileage etc
2. Have the columns in a different order than in the master spreadsheet. I want them in a specific order; different than how the master sheet has it.
3. Update in real time. If a new car is added to the spreadsheet, it should automatically be added onto the other spreadsheet.
4. One page per car model. One page for Tacoma, one page for Tahoe, etc.
I have been told not to touch the master spreadsheet. I can only send the data to another page to manipulate.
Here is what I tried so far. I formatted the master spreadsheet into a table. On a separate page I used '=' then linked each of my desired columns of data into a separate table. I then used the advanced filter button on the top ribbon. This allowed me to filter each car model. I then did this for each page. However, when I would try and sort each column it would give me an error because it is in an array.
The Ideal image shows my work so far, keep in mind that I still cannot sort.
The master shows a small portion of our spreadsheet. It has about 30 columns.
Anybody have any advice for me? Any help would be appreciated!
|