| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to transfer text to an sheet if the cells en range contains a
Hi,
I am trying to collect comments from sheet1!A1:A30 in sheet2, but not all cells in A1:A30 contains a comment but are blank. How do I automatic get sheet2 to collect all comments and only the comments from sheet1? I have tried using the ISTEXT, but it can't be used on a range. Hope someone can help me, thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to Automatically transfer specific Data from Sheet 1 to Sheet | Excel Worksheet Functions | |||
| Concatenating a range of cells from another sheet, possible? | Excel Worksheet Functions | |||
| Transfer/Copy Sheet, Dynamically linked Sheet | Excel Discussion (Misc queries) | |||
| Formula to transfer text from merged cells to single cell? | Excel Discussion (Misc queries) | |||
| Counting Occurrence of Text within Text in Cells in Range. | Excel Worksheet Functions | |||
Threaded Mode
