Hi, I'm not great with Excel so any help is appreciated.
Right now I have a fairly large table with each row being a separate inventory item and each column being a quality of that item. For instance (this is not the data):
Seats Tires Floats Price
Car 4 4 No 20k
Boat 2 0 Yes 50k
Motorcycle 1 2 No 10k
Raft 1 0 Yes 1k
Truck 2 18 No 100k
The table is fairly dynamic and is updated at least once a day and has a varied number of rows (hence table). This is all on tab 3. Tab three will eventually hidden/locked as not all data will be shared with users. On tab 1 I need to build a query that users will select criteria, such as more than one seat and more than 2 tires.
What I need to do from here is have Excel pull the table values based on the criteria and make a new list/table etc with the ones that meet the query criteria. I dont really know where to start so any ideas would be great.
So basically I want to do an advanced filter but I want the results to go to a new spreadsheet and be based on criteria from a third spreadsheet.
Thanks for whatever hints you can give!
Right now I have a fairly large table with each row being a separate inventory item and each column being a quality of that item. For instance (this is not the data):
Seats Tires Floats Price
Car 4 4 No 20k
Boat 2 0 Yes 50k
Motorcycle 1 2 No 10k
Raft 1 0 Yes 1k
Truck 2 18 No 100k
The table is fairly dynamic and is updated at least once a day and has a varied number of rows (hence table). This is all on tab 3. Tab three will eventually hidden/locked as not all data will be shared with users. On tab 1 I need to build a query that users will select criteria, such as more than one seat and more than 2 tires.
What I need to do from here is have Excel pull the table values based on the criteria and make a new list/table etc with the ones that meet the query criteria. I dont really know where to start so any ideas would be great.
So basically I want to do an advanced filter but I want the results to go to a new spreadsheet and be based on criteria from a third spreadsheet.
Thanks for whatever hints you can give!
