No. You can do it with a macro, but not with functions.

You may be able to achieve what you want with If statements in Sheet2, as in:

=if(j3="date",sheet1!c1,"")

Copy down as needed.

--
Regards,
Fred


"Jon" wrote in message
...
hi ,
i want to move column#3 from sheet#1 to Sheet#2 if cell J3 in sheet#1 filled
with
date
is that possible
thanks