Forum Discussion
Transferring content from sheet1 to sheet2
Well, there may be a more efficient way, but with a "Helper" column to identify the WHITE or RED categories in your first table, this FILTER function worked. See the attached file
=FILTER(Foglio1!A2:B35,Foglio1!C2:C35="Y")
Thank you very much mathetes .
It appears that the FILTER function is not available on my Excel version (Home 2019)!
Hmm...I'm on Excel at home; here's the product info ...
So then, you might just use the ability that's more longstanding, on the Data tab, to Filter. Put your cursor in one of the cells in your table and select Filter (you'll see it there on the right in the screen capture below). Once that has appeared, you can select the criteria you want by clicking on the little caret in the column heading and selecting the red and white categories, as I've done in the second image
after which you can copy and paste.
Dear mathetes ,
Actually the FILTER function available with Office 365 is the right one.
The manual filtering option requires the user to take an action, that is what I need to avoid.
Any other suggestion, maybe with macros, which could hit the target?
Thank you
