Good Afternoon Everyone,
I have a table that I am trying to bring in values based upon a pivot table I created. My goal is to bring in the values for a specified date. My table is set up from the current day and out. I am struggling using get pivot data because my column of dates is a formula =now() + 1 ect. Any ideas on how to bring in the data with getpivotdata, index and match, ect?
I really appreciate anyone's input.
Here is how my table is set up:
(C)ustomer 11/16 11/17 11/18 11/19 ...............
a
b
c
d
My pivot table is set up the same way. However the pivot starts on the first day that there is data so it might look like this
(C) 11/18 11/19 .................
a values
b values
c
d
I have a table that I am trying to bring in values based upon a pivot table I created. My goal is to bring in the values for a specified date. My table is set up from the current day and out. I am struggling using get pivot data because my column of dates is a formula =now() + 1 ect. Any ideas on how to bring in the data with getpivotdata, index and match, ect?
I really appreciate anyone's input.
Here is how my table is set up:
(C)ustomer 11/16 11/17 11/18 11/19 ...............
a
b
c
d
My pivot table is set up the same way. However the pivot starts on the first day that there is data so it might look like this
(C) 11/18 11/19 .................
a values
b values
c
d
Last edited: