Hello, first time poster here
I apologize in advanced if this answer is easily obtainable, but I was having a hard time phrasing exactly what I am looking for.
Background: I have a VBA userform (my first time using VBA actually) that is close to finalized and fully functioning. This user form populates a fairly large archive matrix of data and then the matrix populates a pivot table on a separate sheet. I created this using a pretty extensive existing archive of data, so naturally there are a lot of blanks because users were never 'forced' to enter all the required data. I was able to change most of my (blank) headers to something more desirable. My area of concern involves a combobox on the userform that has "Other" as a drop down option populated from a name range.
My Question: I want to change my (blank) label for this same name range to "Other" also, but I want to know if there is a way for both my (blank) cells and the ones truly filled in as "Other" to report to the same Slicer and PivotTable label. I've thought about simply changing the blank cells to other." The issue is, since approx. 3000 lines of this data already existed, it would be inaccurate to label them in the archive matrix as "Other," however it would be appropriate, and desired, for the data summarization and reporting on the PivotTable.
In Summary: Can 2 different values (blank cells and ones labeled as "Other") report to the same Field Label on a Slicer/PivotTable?
Again, this is my first time posting, so please let me know if clarification or additional information is helpful. I cut out only small portions of the screen to preserve some company sensitive information.
Thanks!
I apologize in advanced if this answer is easily obtainable, but I was having a hard time phrasing exactly what I am looking for.
Background: I have a VBA userform (my first time using VBA actually) that is close to finalized and fully functioning. This user form populates a fairly large archive matrix of data and then the matrix populates a pivot table on a separate sheet. I created this using a pretty extensive existing archive of data, so naturally there are a lot of blanks because users were never 'forced' to enter all the required data. I was able to change most of my (blank) headers to something more desirable. My area of concern involves a combobox on the userform that has "Other" as a drop down option populated from a name range.
My Question: I want to change my (blank) label for this same name range to "Other" also, but I want to know if there is a way for both my (blank) cells and the ones truly filled in as "Other" to report to the same Slicer and PivotTable label. I've thought about simply changing the blank cells to other." The issue is, since approx. 3000 lines of this data already existed, it would be inaccurate to label them in the archive matrix as "Other," however it would be appropriate, and desired, for the data summarization and reporting on the PivotTable.
In Summary: Can 2 different values (blank cells and ones labeled as "Other") report to the same Field Label on a Slicer/PivotTable?
Again, this is my first time posting, so please let me know if clarification or additional information is helpful. I cut out only small portions of the screen to preserve some company sensitive information.
Thanks!
