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

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

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

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

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

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

I have a log which several of my staff enter information into daily. They generally work Monday through Friday; however, sometimes work weekends. Therefore, I need the log to be inclusive of all dates from log's origin forward (9/21/12-current). I am struggling to create a VBA code which would...

I am trying to extract multiple dynamic lists from a range matching certain criteria. I need to extract from the "Providers" sheet unique, dynamic lists without blanks to "Clinic" sheet by matching Row 1 on "Clinic" to column E on "Providers" Here is an example...

I am trying to find a provider for a patient using the following conditions: -if seen by multiple providers, choose the one with the most visits, then choose most recent visit -if equal number of visits by providers, then choose most recent This is the last formula I have started to work...

I am tracking census information in horizontal dynamic ranges on an Input! sheet. The information is being compared among two organizations. Changing the layout is not prudent in this case. The date is in row Input!3:3 and the values are in row Input!5:5 for organization 1 and Input!32:32 for...

1. I am tracking census information in horizontal dynamic ranges on an Input! sheet. The information is being compared among two organizations. Changing the layout is not prudent in this case. The date is in row Input!3:3 and the values are in row Input!5:5 for organization 1 and Input!32:32...