I used the Automate feature in excel to automate some manual tasks that are performed every day at my job. I modified it a little to obtain the code below. My issue is that when copying data that is filtered (by value= “Virginia”), and pasting it, I am getting all the rows, instead of only the filtered ones. How can I accomplish this? Please see code below.