Copy entire rows matching condition to a new sheet

  • Thread starter Thread starter JP
  • Start date Start date
J

JP

Hi

I want to copy entire rows matching a condition to a new sheet.

The original sheet contains for example a column called impact with values
between 1 and 20. Is there a possibility to automatically copy all rows with
an impact > 16 to a new sheet called Priority 1, all with a value between 12
and 16 to a sheet priority 2, etc instead of copying the sheet manually,
sort the data manually and delete those rows not meeting the criterium?

Thanks very much
 
This could be done by using the data>filter>autofilter. Record a macro while
doing it so you can modify to do it again.
 
JP,

Data - Filter - Advanced Filter does just this. Set up your criteria range
for Impact > 16 etc., and it'll do it. Check it out. To automate it, you'd
need a macro.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copying Row Code Doesn't Copy Conditional Formating 10
Inserting a Copied Row inside a table 6
Copy Conditional Formatting to Another Sheet 3
Get Name of Sheet to use in Macro 11
moving rows to another sheet 3
Copy certain rows to new worksheet 1
Macro to copy portion of each sheet and paste into the first sheet asa picture 1
Copy of value from one sheet to another with matching column values 1

Back
Top