Recent content by jdppep

I am trying to update a pivot table field using a dropdown list. The code I have is below. I receive the following error when attempting: Run-time error '1004' Unable to set the CurrentPage property of the PivotField class Private Sub Worksheet_SelectionChange(ByVal Target As Range) If...

I have updated the workbook to include the code below in sheet 'Dash-2'. I incorrectly referenced 'Dash-1' in my previous post, as I should have referenced 'Dash-2'. Here is the file: https://skydrive.live.com/redir?resid=2730E514E2E6C670!271&authkey=!AFWhluxXyHm_hvo&ithint=file%2c.xlsm This...

Luke, Any suggestions on how to apply the ActiveX dropdown with VB to change the slicers on this SkyDrive file: http://sdrv.ms/1d6rXcx For example, I want the dropdown in cell F4 on sheet 'Dash-1' to change the filters on both of the "Specialty" slicers located on sheet 'Dash-1'. For some...

This is great! Thanks!

Is it possible to control multiple slicers using a dropdown list? How could I do this? Thanks!

I have been referring to the challenges Hui mentioned above; however, have been unsuccessful applying these to my dashboard. I have uploaded a sample file to SkyDrive (it was too large to upload on here at 3.54mb)...

I am trying to extract a column of data from a table to another range and remove duplicates dynamically. Suggestions?

My document contains about 50 locations. These are listed in a drop-down menu and populate a dashboard based on the drop-down selection. I am looking for a code to automatically change the drop-down selection (starting at the first selection), print to .pdf, save the file and proceed to the...

Thank you! I needed to add the formula to the data table. Simply adding it to the named ranged was unsuccessful.

SirJB7, Thanks for the reply! When I try this: =IF(OFFSET(EODTasks,MATCH(EndDate,DateList,0)-1,0,EndDate-StartDate+1),(OFFSET(EODTasks,MATCH(EndDate,DateList,0)-1,0,EndDate-StartDate+1)),NA()) The chart continues to plot these data points as zeros. The formula itself returns #Value when I...

I am trying to plot a dynamic line graph without zeros or blanks. The line graph updates by selection of a start and end date in dropdown lists. I have a named range for each chart series, ex: EODTasks_Graph =OFFSET(EODTasks,MATCH(EndDate,DateList,0)-1,0,EndDate-StartDate+1) How do I make...

I was placing the sparkline in a merged cell, which did not work. After defining the sparkline, I was able to merge the cells. Thanks!

Specifically, how should I enter the range information? If I simply select the individual cells: =Dashboard!$E$15,Dashboard!$G$15,Dashboard!$I$15,Dashboard!$K$15,Dashboard!$M$15,Dashboard!$O$15,Dashboard!$Q$15,Dashboard!$S$15 and name them as a range "Sparkline" I receive the following...

Is it possible to create a sparkline using a non-contiguous range? All data is located within the same row; however, evenly spaced, two cells apart. Would a named range work and if so, how would I name a range the sparkline would recognize? My data is located...

I am attempting to build a calendar without VBA or array formulas. I have successfully created a calendar using dummy cells; however, am trying to write formulas which would not require these dummy cells. The formula which works, but requires dummy cells (in orange)...