PDA

View Full Version : Copy filtered rows



adamsm
05-24-2011, 10:59 AM
Hi,

Im trying to figure out a code that would filter column "M" of the active sheet with the value "Trash" and copy all the visible rows from column "P" and paste them in column "K" of sheet 2.

Any help on this would be appreciate.

My data in the active sheet starts from row 17. and data in sheet2 starts from row 11.