+ Reply to Thread
Results 1 to 2 of 2

Copy, Find and paste between pivot table and worksheet

  1. #1
    Forum Contributor
    Join Date
    09-13-2010
    Location
    Poland
    MS-Off Ver
    365
    Posts
    122

    Copy, Find and paste between pivot table and worksheet

    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

  2. #2
    Forum Contributor
    Join Date
    09-13-2010
    Location
    Poland
    MS-Off Ver
    365
    Posts
    122

    Re: Copy, Find and paste between pivot table and worksheet

    Hi,

    I have attached the example of excel file
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1