Forum Discussion
Transferring entire row based on single cell
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!!
3 Replies
- You could try to execute it in two steps
1) Use the unique function in excel to pull out unique values to a second column https://support.microsoft.com/en-us/office/unique-function-c5ab87fd-30a3-4ce9-9d1a-40204fb85e1e
2) Use the unique values column to then create worksheets using a VBA macro (here is an article that shows you how https://www.get-digital-help.com/quicky-create-new-sheets-vba/)
Hope this helps!
Best,
bp- Thank you for sharing. I need to go one step further and actually transfer the entire row to the associated worksheet for each line item with a specific search in a single column. So every row that has Peaches will be transferred to the "Peaches" worksheet.
- mmm...Can you add an additional step to do something like this? another script to copy over an entire row based on the contents of a cell value.
https://www.youtube.com/watch?v=TJoRUwrEe0g
To be honest, this might be a case of using Python to manipulate the file to create arrays and if value X appears then copy array to worksheet X.
https://www.youtube.com/watch?v=TJoRUwrEe0g
