Criteria from Sheet 1 copied over to Sheet 2 if it meets certain criteria

Hi everyone,

First time posting here so thank you for your patience and for your help. I manage used car inventory for 4 Land Rover & Jaguar dealerships. I want to create an excel spreadsheet that can help me manage my inventory better. So basically in Sheet 1 will be my group data that has all my used car inventory. I want to be able to use a formula that will allow me to pull from that group data into another sheet. For example, I want to see how many Range Rovers we have that are Certified Pre-Owned and have the Luxury Package. What is the best function or formula? And, if possible, when I update my inventory I would also like Sheet 2 to update as well. Thanks everyone!

Edit: I uploaded a sample of what my data looks like. Basically when it comes to repricing our vehicles I would like to be able to have all the rows from Sheet 1 transferred over to Sheet 2 if it meets the criteria (ie Range Rover Sport and Factory Certified). Thanks again!

There are a number of formulas and VB procedures that can accomplish this. Attached is a sample of what I usually utilize.

If returning more than a few hundred rows, I usually opt for a VBA solutions.

HI, welcome to the forum

Another option for this might be a Pivot Table. Can you upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.

This could go almost anyway, using a PT based on your sample data.

I put something together really quick using...
Report Filter = Make and Model
Column labels = Status
Row labels = Trim
However, you could customize this to whatever you want...

	A	B	C	D
1	Make	(All)
2	Model	RANGE ROVER SPORT
3
4	Count of Status	Column Labels
5	Row Labels	Factory Certified	Sale as Retail	Grand Total
6	EBONY/LUNAR	1		1
7	ESPRESSO		1	1
8	Grand Total	1	1	2

Can you provide a sample of what your expected outcome would look like?