Hi guys,
I have chart that forum guru Andy Pope helped me with. The 3rd sheet (Data) provides the information of the Y-positions.
What I want to do is to be able to remove this data sheet and have all the information be pulled from the first sheet (Stakeholders) so that when filtering it will only display valid names. I've tried moving the Y-position values to the first sheet but I can't get it to work.
Does anyone have any suggestions? Attached is the spread sheet I'm working on.
Cheers!
Bookmarks