Forum Discussion
Data Validation
Hello All, I have a data validation question. I created a costing spreadsheet that can pull data from a master spreadsheet so that multiple copies of the costing spreadsheet can always be current / ...
Hey Hans, Thanks for the reply. The hidden column idea is an option that I explored (I should have explained that also), however, in the actual spreadsheet there are multiple filtered spill ranges and multiple lists. I will resort to that if I cannot figure out a way to build the formula into the data validation formula bar but ideally I stay away from that since I would need 10 to 15 hidden columns per page and part of me worries about hidden ranges becoming an issue in the future. If there isnt a simple solution then I will definitely go that route though. Thanks for the reply!