Forum Discussion
Copy row from one sheet to another based on cell
Hi, I'm trying get rows from table 1 pasted into correct sheet based on cell value. I've attached an example of what I'm trying to have automated. You'll see that there are 3 x sheets. If ...
If you have the most recent version of Excel, the FILTER function will do what you want. If you don't have it, I recommend upgrading.
Here's a video that will help you as well: https://www.youtube.com/watch?v=9I9DtFOVPIg