Hello,
I created a pivot table that holds the following information: Month, day of the week and milestone data. What I am looking to do is dynamically pull the information from a pivot table into an excel template calendar. To date the only way I know how to do this is 1.) input = 2.) Scroll to the worksheet 3.) Enter and the data populates on the calendar. Is there a formula I can use to update the calendar?
I created a pivot table that holds the following information: Month, day of the week and milestone data. What I am looking to do is dynamically pull the information from a pivot table into an excel template calendar. To date the only way I know how to do this is 1.) input = 2.) Scroll to the worksheet 3.) Enter and the data populates on the calendar. Is there a formula I can use to update the calendar?