Jul 05 2022 03:25 PM
Transferring entire row based on single cell
How to transfer entire row to new WS based on one cell contents
Hi all,
I'm trying to transfer the entire row of an imported worksheet based off 1 column category.
So Column F is the category I'm trying to SORT. I need to have a separate sheet for each type of item.
For example if F has "Peaches", "Pears", "Apples" I need each line to transfer to a new sheet one for Peaches, one for Pears, and one for Apples.
ANY HELP would be greatly appreciated.
I need to also be able to do this over and over again as Excels come to me.
Excel version 16.62 for Mac
Mac OS Big Sur
Very much appreciated!! Ciao!
Cici!!
Jul 05 2022 07:27 PM
Jul 06 2022 06:00 AM
Jul 06 2022 08:15 AM