Fellow Forum Members,
I have a hyperlinked Sheet1 list of 2,500 PDF ebooks that cover a variety of subjects. Now I have the task of organizing all these ebooks by subject on a separate Sheet2 worksheet. The problem I'm having occurs when I try copying hyperlinked filtered rows from Sheet1 and then paste them in Sheet2. For example I have 55 ebook titles relating to Finance that show up as row 35, row 56, row 88, row 145, row 568, row 890, row 1400, etc. after I apply a custom filter for the word finance. When I select these rows and paste them into Sheet2 my hyperlinks get lost. If I paste special -> forumlas only, the hyperlinks sometimes showup and sometimes get lost. Can anyone tell me what is the best way to copy & paste filtered hyperlinked rows so that the hyperlinks stay intact and the 55 row numbers are consecutively numbered in Sheet2? Any help will be greatly appreciated. Thanks.