Hi,
I want to make a macro that copies cell, finds the same phrase in other worksheet and copies hyperlink from found result to first place.
so, i have 2 worksheets:
1. one with 3 columns <Name, Price and Hyperlink>. 2 first contains many of repeating cells. last one, Hyperlink, has only different cells.
2. second worksheet is a pivot table made of first 2 columns of first worksheet(Name, Price). so pivot table tells me how many of repeated styles are in first worksheet.
I want to make a macro that goes to first style in pivot table (cell A2) copies the text; then goes to first worksheet, looks for particular name and copies hyperlink from the same row but column 3 (by the way it has the same text + one extra word), called Hyperlink; and then goes back to pivot table and adds hyperlink to the cell in A2 or paste this hyperlink to next free cell in the same row, in this case it is column C. then, I want this macro to repeat it on next rows in pivot (A3, A4, or end C3, C4, etc). so I want to make it a loop macro
p.s. pivot table does not copies hyperlink, so adding of hyperlink column to pivot table wotn solve the problem
many thanks for your help
Bookmarks