Search results

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)...

Since you were able to define the merged list, would it be possible to use a SUMIF function, based on multiple matching criteria to populate the productivity table(s)?

Hi SirJB7! I agree with the merged cell complication. I am trying to clean up someone else's mess; however, I have another application this solution will also fix. I made a couple changes to the productivity sheet. When I added lines, the references changed and are no longer correct. I added a...

You have been incredibly helpful. Thanks again!

Wow, thank you!! I have not had a chance to completely go through this. What formula can I use across CJ:J7 on Productivity! to retrieve the appropriate merged value?

The data in the second worksheet (Productivity!) should be the sum of the data in the first worksheet (ProcessingLog!). Frequently, the data will be incomplete as multiple users fill in their respective information on the ProcessingLog! sheet. Additionally, the staff typically do not work on...

Hi SirJB7! Thanks for the reply. Please see the updated attachment. Thanks!

I am attempting to retrieve values from a series of merged cells without VBA. I realize merged cells can cause complications; however, I think this can still be done. On Sheet: "Productivity", I am trying to match the productivity of each staff to the various tasks. In cells $C$7:$J$7, these...

Hi SirJB7, thanks for the link. It appears what I am trying to do should work. This code is working for me now: Private Sub Workbook_Open() Dim myDate As Date Dim numRows As Long Dim oldDate As Date 'Which worksheet are we dealing with? Worksheets("ProcessingLog").Select ' switch off...

Post #5 has a sample file. I was able to get this to work on a protected document; however, it does not work when the document allows shared editing. I now receive a message "Run-time error '1004': Unprotected method of Worksheet Class failed. My complete code is as follows: Private Sub...

I received the following error: "Compile Error in Hidden Module: ThisWorkbook. This error commonly occurs when code is incompatible with the version, platform, or architecture of this application."