Copy rows to new spreadsheet
 

Hi: I have a database in excel of about 500 records. I need to select a
group of about 30 records based on the field info in cell b3 -- the line for
the first record. I usually use the autofilter function and just key in
field info buy it only let's you do 2. I need a bunch more. Then, I want
to copy these 30 record to a new page. Any ideas? Thanks, Wayne

Copy rows to new spreadsheet
 

You could use the next available column. Put in a formula that determine
whether that row qualifies or not

=if(And(many conditions),"copy","don't")

then autofilter on this column.

another approach would be to use the advanced filter which both supports
many conditions and will also copy to another sheet (although you must
initiate the command from the destination sheet if you are doing it
manually).

--
regards,
Tom Ogilvy


--
Regards,
Tom Ogilvy


"Wayne B" wrote:

Hi: I have a database in excel of about 500 records. I need to select a
group of about 30 records based on the field info in cell b3 -- the line for
the first record. I usually use the autofilter function and just key in
field info buy it only let's you do 2. I need a bunch more. Then, I want
to copy these 30 record to a new page. Any ideas? Thanks, Wayne