Hi

I have the result from a pivot table, named tn1, filtering of say 3(number of rows can vary) rows. Using VBA how do I look up the 3 rows in original data table named loc2, and delete the 3 rows and then add to another data list named loc1. (data lists in different worksheets) loc1 Sheet1 and loc2 sheet2
It is the VBA to get the rows from the Pivot that is the problem, otherwise just a move or cut/paste. Thanks

Charles Harris