Please help with this macro.

rcdgreat

New Member
Joined
Mar 17, 2011
Messages
13
I want to create a macro wherein after filtering through a set of data I want to copy several rows based on a condition.

For example: I have two columns named Name & Civil Status. Then I will filter all records with Single as the Civil Status. Once filtered let's say the condition is I just need to copy the first 5 of the filtered record without copying the hidden ones.

Hope the example makes my question clear.

Thank you in advance.
 

Some videos you may like

Excel Facts

Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple

Watch MrExcel Video

Forum statistics

Threads
1,109,001
Messages
5,526,203
Members
409,686
Latest member
Tori83

This Week's Hot Topics

Top