As for the how: I highlighted row E in the monthly tabs, and chose Data validation > List from range, and entered the range ‘non-fixed categories’!B3:B14.
As for the how: I highlighted row E in the monthly tabs, and chose Data validation > List from range, and entered the range ‘non-fixed categories’!B3:B14.
Written by