| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extracting information from records to another sheet automatically
Dear experts,
I have a list of students with ten columns of data to the right and then an eleventh column containing textual comments. I want excel to automatically look at the range of student results (A5:L300), determine which students have comments (not all students have comments) and extract the student name and the comment and display this on another sheet. I can see how this can be done with an advanced filter however: I want the results on another sheet and I don't want to have to do it manually. Is there any way I can achieve this? kind regards Molly |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extracting information from records to another sheet automatic | Excel Worksheet Functions | |||
| How to copy records containing a specific date range to new sheet? | Excel Worksheet Functions | |||
| copy subtotal information to new sheet | Excel Worksheet Functions | |||
| How do I determine automatically that a sheet is empty? | Excel Worksheet Functions | |||
| how can i automatically copy the information in one cell on a she. | Excel Worksheet Functions | |||
Threaded Mode
