Sorting and copying table

[forothergaming]

I'm sorry i need some help here. I have a Table list that any formulas or macros would help me alot. Could you help me to sort and copying specific item criterias form one sheet to another with auto updates. In this case vegetables and fruits. I've done it manually but it would be a pain for larger list.

 

[abdelfattah]

Hi,,
I don't think this is right way to do that.
I suppose to make another column as classification like this (look at column D)

Sample.xlsm
	A	B	C	D	E
1	NO	DATE	PRODUCT	CLASSIFICATION	SELL
2	1	01/01/2023	Tomato	Vegetables	20
3	2	02/01/2023	Banana	Fruit	20
4	3	03/01/2023	Pear	Fruit	10
Base

 

[forothergaming]

Hi,,
I don't think this is right way to do that.
I suppose to make another column as classification like this (look at column D)

Sample.xlsm
	A	B	C	D	E
1	NO	DATE	PRODUCT	CLASSIFICATION	SELL
2	1	01/01/2023	Tomato	Vegetables	20
3	2	02/01/2023	Banana	Fruit	20
4	3	03/01/2023	Pear	Fruit	10
Base

Well... I know that's a bit complicated, I need those sheets for different analisys. So if you could help me with that.

 

[Joe4]

Since you are using Excel 2021, you should have the new FILTER function (not to be confused with the old Filter functionality).
The FILTER function is a new, dynamic spill function that you just enter your criteria, and it returns ALL rows matching your criteria.
So as new data is added to the original list, it should automatically be reflected on the other sheets using the FILTER function.

I think you just need a column indicating Vegetables/Fruits (as I see nothing in there currently telling Excel which sheet each one should go to!).

Have a look here for details and examples.