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