Sorry if this has been asked before - I tried searching but couldn't find a potential solution. In my excel file, Sheet1 gets populated with data from a bunch of individual excel spreadsheets (each spreadsheet's data is on a single row). The cell in the "title" column of each row gets hyperlinked to its individual spreadheet (located in a sub-folder) via a VB script. This hyperlink is not formula-based - it exists in the "Address" field under menu picks "Insert /> Hyperlink". On Sheet2 there is a macro that is set up to copy a row if a certain condition exists. Everything copies over just fine, but I cannot seem to be able to copy (via VB) the hyperlink address from the original cell in Sheet1 to its copy on Sheet2, which would be extremely useful for the users to have.

Any help on this matter is much appreciated. I have inherited this file and need to manage it and improve it since the creator of the file isn't around, but I can't fix this particular problem since I am just still picking up VB.