Click on the column A header cell and pull down:

Data FIlter Autofilter

make your selection and then copy the visible rows to another sheet.
--
Gary''s Student - gsnu200906


"Emece" wrote:

I receive a sheet that has the following information in column A: client ID,
and I have several IDs. I want to obtain only the information that
corresponds to ID A001 and ID A002, creating one new sheet for each ID. Is
this possible?

Thanks in advance

Regards,
Emece.-