Hello,
I have a sheet (Sheet1) with several hundred rows.
Column A is part numbers, columns B - J contain data regarding the part number. Due to a request, I need to setup a second sheet (Sheet2) in which a user can type the part number into a cell, lets say A1, and the macro would search Sheet1 - column A for the part number and then copy & paste that part number's entire row onto Sheet2, row 3.
Since a majority of cells contain hyperlinks a simple Vlookup won't work. And wrapping the Vlookup in the HYPERLINK function still doesn't retain the hyperlink.
So my thought is to use a macro that will copy & paste rather than just displaying the cell's text. Maybe there is a easier way to handle this without the use of a macro, but I am lost.
I appreciate anyone's help!
Bookmarks