Filter exact items

Hi all,

I’m looking for solution to filter items from my product list.

I have one document with all the categories and the products in those categories. And second file is a list of all the product’s combined with prices etc.

I want to make separate file for every category.

So I need to make a custom filter to filter the items from column:A in column:B

Example:
Columns A:

TS0100
TS0150
TS0200
TS0250
TS0300
TS0350
TS0400
TS0450
TS0500
TS0550
TS0600
TS0650
TS0700
TS0750
TS0800
TS0900
TS1000
TS2000
TS3000
TS4000
TS5000
TS6000
TS7000
TS10000
TS15000
TS20000
TS30000
TS50000
TS100000

Column B

TR8EKIT
TR8ERTR
TR8TERTR
T8V3
TR8KIT
TR8TRTR
T02001
T02002
T02003
T02004
T02005
T02006
T02007
T02008
T02008S
T02009
T02010
T02011
T02012
T02013
T02014
T02015
T02016
T02017
T02018
T02019
T02020

What is the easiest way to do it?

Sorry, I’m a newby wih LibreOffice Calc

Hi @epiblue, IMO except you really have the need for have the items in a separate places, please don’t do it. Adding a column with the category I think is more useful, and you have several tools that work nicely with tables, as the Pivot table or Subtotal and the rest of tools in Menu/Data.

You can do it with Menu/Data/Filter/Standard filter, choosing in more options set up a destination for filtered data.

Calc documentation