cogswel__cogs
Board Regular
- Joined
- Jan 3, 2018
- Messages
- 181
So I am building a vlookup for a team pivottable.
In theory Boss will color codes result cells in pivottable he'd like explanation for.
Users are instructed to go into cell of particular column click on equals then click on colored cell.
When they do get pivot generation gets built.
The column next to that uses formula text to capture cells pivot path with "=".
After comment is written worker is instructed to copy paste-special the columns into another tab where all comments are being stored.
Then using vlookup of formula text without "=" is searched a brings back the comment into cell next to that.
So the user knows it works he/she sees comment show up in that column. The user then just clear contents in the get pivot and original comment column.
It works in testing but before I bother to go through steps wanted to make sure there was not easier way. I will often do really stupid unnecessary steps.
I don't want to use macros because security reasons.
There are slicers I have that will effect the Amounts so I am probably going to identify the amount the Boss was seing so worker knows amount he should be responding to and may have to unfilter slicers etc. . I am perfectly happy with note showing up with any amount as the area remains the same. But it will allow changes in the pivot string such as division to only show when that division criteria is selected report.
In theory Boss will color codes result cells in pivottable he'd like explanation for.
Users are instructed to go into cell of particular column click on equals then click on colored cell.
When they do get pivot generation gets built.
The column next to that uses formula text to capture cells pivot path with "=".
After comment is written worker is instructed to copy paste-special the columns into another tab where all comments are being stored.
Then using vlookup of formula text without "=" is searched a brings back the comment into cell next to that.
So the user knows it works he/she sees comment show up in that column. The user then just clear contents in the get pivot and original comment column.
It works in testing but before I bother to go through steps wanted to make sure there was not easier way. I will often do really stupid unnecessary steps.
I don't want to use macros because security reasons.
There are slicers I have that will effect the Amounts so I am probably going to identify the amount the Boss was seing so worker knows amount he should be responding to and may have to unfilter slicers etc. . I am perfectly happy with note showing up with any amount as the area remains the same. But it will allow changes in the pivot string such as division to only show when that division criteria is selected report.
Last edited:
