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 ...
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
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
