How to move a column from one sheet to another by using functions

J

Jon

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
 
F

Fred Smith

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.
 
Top