narsing rao
Member
Hi ,
i have pivot table with values , now i want to multiply those values with other values in different sheet in a such away that ,cell data look for the same user name first and then the values should get multiplied.
small example below:
sheet 1
abc_Report xyz_Report
John 5 0
Mark 0 2
sheet 2
Processing time John Mark
abc_Report 20min 20*5 0
xyz_Report 50min 0 50*2
please find the example in pic view
as shown in sheet 2 values should get populated.
in above processing time values are hard coded. they wont get changed.
in above example i have given example with two values but in real scenario it is dynamic like user may increase or decrease.
any help is appreciated
i have pivot table with values , now i want to multiply those values with other values in different sheet in a such away that ,cell data look for the same user name first and then the values should get multiplied.
small example below:
sheet 1
abc_Report xyz_Report
John 5 0
Mark 0 2
sheet 2
Processing time John Mark
abc_Report 20min 20*5 0
xyz_Report 50min 0 50*2
please find the example in pic view
as shown in sheet 2 values should get populated.
in above processing time values are hard coded. they wont get changed.
in above example i have given example with two values but in real scenario it is dynamic like user may increase or decrease.
any help is appreciated
Last edited: