I did a transfer using VBA. I am having trouble now filtering the data and sorting it. I used the following in VBA:
Sub Copy()
Sheets("Data Entry").Range("A5:A654").Copy Sheets("Try1").Range("A5")
Sheets("Data Entry").Range("A5:A654").Copy Sheets("Try1").Range("D5")
Sheets("Data...