MACRO to copy and paste pivot table data

[timhue88]

Hi all,

i am currently working on a project which requries me to copy and paste pivot table data. for example


in sheet A i have these data in pivot table

A B C
123USD123 1,000,000 1,000,000
234USD234 1,000,000 500,000
345USD345 1,200,000 1,200,000
456USD456 1,000,000 500,000

What i need the macro to do is to double click on column 2 and 3 of row 234USD234 and copy the corresponding data into another worksheet in row1 and row 600 respectively.

In addition, i would like it if it could ignore row 123USd123 and 345USD345 as the values of B and C match.

thank you!

 

[Greg Truby]

You'll need to post your code (please use code tags when you do) in order for us to help you with whatever portion of your macro is causing you problems.

 

[timhue88]

to be honest, i dont know how to code. Thus, i constantly use record macro function on excel.

However, i am unable to use this as record excel captures the cell but and wont move down to look at the next cell.