VBA to Extract certain Rows to a new worksheet

thunder_anger

Board Regular
Joined
Sep 27, 2009
Messages
206
Hi All
I have this sample of data


what i need is a vba macro to only extract rows with "late Pen" and paste them into a new sheet
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

second question

if i have about 100 files that have the same structure in the same folder
can i extract rows "in the first question" from every workbook and past it into a new file with a sheet for every file
 

Some videos you may like

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.

Watch MrExcel Video

Forum statistics

Threads
1,109,538
Messages
5,529,431
Members
409,876
Latest member
Akash Yadav
Top