Named Regions and Data Validation – Great Time Saver

I was given a curious problem the other day by a client who required some Microsoft Excel consultancy.  They had an issue whereby multiple worksheets referenced the same information in data validation drop downs.  So lets say one of these drop downs was people within the team and was used to assign work to individuals.

Continue reading Named Regions and Data Validation – Great Time Saver