VBA Loop Comparing Two Cells and Copying Value when True

[nalij]

Thanks in advance to anyone that can offer assistance to me with this issue, I am really stumped.

Background:I have a pivot table with a number of slicers that drive the data. On a separate worksheet I am graphing specific values based on a specific time period.

Issue:The problem I run into is some of the slicers change the layout of the pivottable (i.e.: 1/7 data might be in column C for slicer 1 then column B for slicer 2).

I believe the most efficient approach would be to write a loop code that looks at the pivot table and compares the two dates, if the date matches then select the corresponding pivottable value and paste on the graphing worksheet. Run this through until the pivottable has compared all dates to the graphing table.

Layout:

So compare the dates here (Worksheet 2), represented horizontally

Metric	WeekVal
VENDORNAME	01/04/13	01/11/13	01/25/13	02/01/13	02/15/13	03/01/13	03/22/13	03/29/13	04/05/13	Grand Total
Vendor 1	0	1	1	0	1	0	1	1	1	0.666666667
Grand Total	0	1	1	0	1	0	1	1	1	0.666666667

<tbody>
</tbody>

to the dates here (Worksheet 1), represented vertically

01/18/13

01/25/13

02/01/13

02/08/13

02/15/13

02/22/13

03/01/13

03/08/13

03/15/13

03/22/13

03/29/13

04/05/13

<tbody>
</tbody>

If the dates match then take the value from Worksheet 2 and place it in the column immediately to the right of the dates in Worksheet 1. Repeat this process until all the pivottable metric value information is contained within the vertical (Worksheet 1) graphing table.



Thanks again to anyone that can offer advice or proposed solution!!!

 

[nalij]

Anyone have advice on this?