ExcelBanter - Find / List all

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Find / List all (https://www.excelbanter.com/excel-discussion-misc-queries/189376-find-list-all.html)

Adrian Bear

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

Bob Umlas, Excel MVP

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

Adrian Bear

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

All times are GMT +1. The time now is 02:19 PM.