Checking values in different sheets and paste if existing in new cell

MattiasK

New Member
Joined
May 15, 2019
Messages
1
Hi,

I have a document with different sheets named year (215,2016, etc). Each sheetcontain data from car manufacturers.

Fo example:

Sheet A (2015)
AUDI
BMW
Toyota
Ford
Volvo
Volvo

Sheet B
(2016)
BMW
Citroen
BMW
BMW
AUDI




In each sheet, a manufacturer can be stated several times. I need to getdata that the manufacturer is in the list. The result would look like:



Sheet C(Overview)
BMW
Toyota
Citroen
BMW
AUDI
Ford
Volvo


As you can see,Citroen was only in sheet B and Toyota in sheet A but in the overview I know itis used un-dependent on what sheet it is in. Others were stated several times in different sheets.




Thanks.




/M
 

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

Forum statistics

Threads
1,223,911
Messages
6,175,325
Members
452,635
Latest member
laura12345

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top