formulas return a value, they can not perform an action
like copy.

-----Original Message-----
Hi,

This has got me and I need to ask the greaty and wise for
help again.

Is it possible and if so what is the formula to:

Copy data from one work sheet to another if box has
certain criteria.

If a column in one work sheet has any entry in it,
example Page 2 column D,
I would like to Copy (link) a specific row of data in
Page 2 column A to C
into another work sheet ie. Page 1 column A to C.

Hope this makes sense.

Dave

.