By stjohansen1992@gmail.com երկուշաբթի, 24 հունիսի 2019թ
Ավելացնել Excel
Գրառումներ 0
Սիրում 0
Դիտումներ 1.9K
Քվեարկել 0
Բարեւ,

Is it possible to copy a row from one sheet to another one IF its contain one special text?

I have some product from different manufactors, and I only want one of them in my second sheet. I have found ways to sort it, but not in real time.

Like in this first picture I got some few products. When I choose them, I want it copied to my second sheet in real time and only one of the manufactors.
[img]https://i.ibb.co/fYDrJfQ/Main-sheet.png[/ IMG]

This is the second sheet were I want the names sorted out, and only from "Solar"
[img]https://i.ibb.co/h2J5LXT/Second-sheet.png[/ IMG]
Դիտել ամբողջական գրառումը