• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Raw data to in pivot and vlookup using macro

W

webmax

Member
Dear Team,

Attaching the sample file . Which contains three sheets
1) Dashboard
2) data
3) Pivot Table.

My required macro is the Raw data to be make as pivot table. From the pivot table the same has to put as v lookup in the Dashboard file.

The raw data change then the pivot and dashboard file also to be change if i run the macro.

Regards
Shahul
 

Attachments

  • sample data for macro.xlsx
    13.1 KB · Views: 6
Hi:

Why you want to create a pivot for this? Can't you a simple sumif function (like below) in column D of your Dashboard tab?
=SUMIF(Credited!$C$2:$C$4,B2,Credited!$G$2:$G$4)

Thanks
 
You must log in or register to reply here.
Back
Top