| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find / List all
When using "Find" and then "List all" a list of hyperlinks is produced.
Is there any way of copying this list (say into another Excel worksheet)? -- Adrian |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Find / List all
Yes - press Ctrl/A, then Ctrl/C, then paste wherever you want!
"Adrian Bear" wrote: When using "Find" and then "List all" a list of hyperlinks is produced. Is there any way of copying this list (say into another Excel worksheet)? -- Adrian |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Find / List all
Dear Bob,
Thanks for the reply. Sadly, your solution doesn't seem to work. All I copy and paste is the worksheet the first hyperlink points to. Cheers -- Adrian "Bob Umlas, Excel MVP" wrote: Yes - press Ctrl/A, then Ctrl/C, then paste wherever you want! "Adrian Bear" wrote: When using "Find" and then "List all" a list of hyperlinks is produced. Is there any way of copying this list (say into another Excel worksheet)? -- Adrian |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to find a different value within a List | Excel Discussion (Misc queries) | |||
| Find the top five in list | Excel Worksheet Functions | |||
| How to find a find a list of possible inputs to sum a known amt? | Excel Discussion (Misc queries) | |||
| list 1 has 400 names List 2 has 4000. find manes from list 1 on 2 | Excel Worksheet Functions | |||
| find names on list 1 in list 2. list 1 4000 names list 2 400 name | Excel Worksheet Functions | |||
Linear Mode
