Collecting Cells of the same condition

[Moh'd Al-Agha]

Hi all,

I have a table that contains around 7000 records in one
column, and I want to extract only the cells which
satisfy a certain condition to a new worksheet. Is there
any function in Office XP that will scan for these cells
and copy only these cells to the new worksheet?

Thanks in advanced for your help.

M. AL-Agha
(e-mail address removed)

 

[Jason Morin]

I would explore the possibility of a filter (Data > Filter

AutoFilter) and then copying the filtered data to the

new sheet.

HTH
Jason
Atlanta, GA

 

[Ken Wright]

Or Data / Filter / Advanced Filter / 'Copy to new location', then copy that lot
to a new sheet. If you go with Jason's method, and it is just as easy if not
quicker, then you will likely need to select all the data and do Edit / Go To /
special / visible cells only and then copy and paste to a new sheet.

 

[Moh'd F. Al-Agha]

Guys,
Thanks Alot for your fast reply, that would help too much.

I have one more comment to make this clear,
What I'm going to do is to import these data from a txt
file generated by a reporting system. Anyway I have to
update this database periodicaly. Can I make this filter
works automaticaly? that is why I'm searching for a
function.

Thanks again for your reply.