Hey All,
I'm trying how to figure out how to populate the source field of my data validation rule on a cell based on dynamic info.
The data validation field is a dropdown list and it references text values on another page, the problem is that list of text values can be any length (usually a few thousand lines though). I've currently put in this in the source field:
=all_pivot!$B$3:$B$65536
This then lists all of the text values that I want, but also thousands of blank lines of space. I have checked off the ""ignore blank" option in the data validation setup, but the "all_pivot" page has values of 0 in the B column for any blank entries rather than actual blank entries.
PS. I already do have a button on my spreadsheet called "refresh" that runs some VB script, so it's not a problem for me to add some VBscript to perform the action that I desire.
thanks,
Cam.
Bookmarks