I am running a filter that loops through 900+ rows in a sheet and copies certain rows into other specific sheets based on a column value. I have everything else set up but I am struggling to get the copy function to work. I need to use "i" as a row reference and need to copy columns "A:G".
Any help would be appreciated. Thanks
This what I thought would work
Any help would be appreciated. Thanks
This what I thought would work
VBA Code:
Sheet1.Cells(i,"A:G").Copy Sheet2.Cells(LastRow,"A")