You can alway do a sort to get the items together on worksheet 2. You would
need a custom macro to get compact the items on sheets 2. The macro is pretty
simple.

You would need a work_sheet change macro for it to be done automatically
when you enter new data.

"Kattosha" wrote:

I have a worksheet which I continualy add data to and I need to extract
certain information to another worksheet.
ex:
X ALPHA 3/8/07 1234
BETA 3/2/07 2345
X DELTA 2/18/07 3456

If column A contains an 'X' then I need to pull column C and D over to
worksheet 2 in a nice neat list. I need this to be a formula that will
automatically pull the data everytime I enter information on sheet 1. The
sheet needs to look like;

3/8/07 1234
2/18/07 3456

I can figure out how to pull it over, but if the X is on line 456 on sheet
one then the data I need is on line 456 on sheet 2, which creates a lot of
wasted space and I could do manually easier.

Any suggestions would be greatly appreciated

thank you