How to move a column from one sheet to another by using functions
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 |
How to move a column from one sheet to another by using functions
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 |
All times are GMT +1. The time now is 09:26 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com