Forum Discussion
Copy and paste with vba
I have a worksheet that I import several times a day. It lists employees and orders pulled.. What I need to have happen is For each employee (Emp1) it will copy the row and paste it to another work...
TeachASU2020 Why insist on using VBA? You can achieve something similar by using a pivot table where you put the employee in the filter field and then use "Show Report filter Pages" in pivot table options to create reports by employee on demand.
If you are on a modern Excel version you could also use UNIQUE and FILTER to achieve overviews by employee.
See attached for some examples.