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.
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.
