| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| move rows of data seperated in a sheet to a sheet with no separat | Excel Worksheet Functions | |||
| how to move the cursor to column A after entering data column F | New Users to Excel | |||
| How do i keep a column stationary but move the rest of the sheet? | Excel Discussion (Misc queries) | |||
| move contents of column C based on criteria related to column A | Excel Discussion (Misc queries) | |||
| I would like to move from sheet to sheet in a workbook using keybo | New Users to Excel | |||
Linear Mode
