Hi all
I built a spreadsheet which is a travel voucher using lots of drop down lists by naming all of my lists and using data validation and the indirect reference.
The only issue is that I have had to name everything with underscores instead of spaces so that the 'name' function works. The problem is that when you select these items they don't look very nice with lots of underscores in.
Is there any way around this?
Bookmarks