copy filter data

[tpkelley_no]

I have a excel work book that has a work sheet called "all". they also have other named work sheet in the workbook. The other work sheet have the names in column "D". I placed a filter on row 1. I am filtering column "D". After I filter the work sheet "all" column "D" I need a VBA code that will look at the names in column "D" and search for the correct work sheet and copy the row starting with row 2. I will be adding data to the "all" work sheet and I do not want the same data copied twice.

 

[GAdamWTW]

Recording 1 time of you filtering the data, ctrl+A, copy, move to the sheet ctrl+A(or select the first row with data and ctrl+shift+End), paste would do it.
You'd record once and don't need anything special and selecting everything before pasting will prevent duplicates regardless of there being fewer or more rows than before.