Lookup/extraction help

[Kattosha]

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

 

[Joel]

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]

That is one option I thought of but I would like to avoid it. My boss is
excel incompetant and would be unable to run a simple sort, let alone a
macro. I was hoping there was a formula out there along the lines of;

=IF(Worksheet1'!A:A="x",'worksheet1'!B:C,

but I can't figure this out

 

[Joel]

Can your boss push a Button? Not yours? I couldn't resist the joke! You can
add a Command button to your worksheet that can run the Macro. If you look
at the view Menu - Tool Bars. The Control Tool Box Toolbar. Has a command
Button. You can add this to the worksheet. then when the Command Button is
pushed the sort macro will run.

 

[Kattosha]

He's pushed mine probably as many times as I have pushed his*L*

That is an excellent idea, and I think he could manage to do that. It doesn
tlook like its too hard to hook a macro to the button, so I will give it a
shot..

Thank you