Create pop-up menu from range of cells
I'd like to create a table listing financial expenses categories along with summations for each category. I would also like to have pop-up menus in my expenses list whose values come from the main categories table.
I want to be able to expand the categories list in the future and I don't want to have to copy an edited pop-up cell across dozens of sheets.
Is this possible?
I want to be able to expand the categories list in the future and I don't want to have to copy an edited pop-up cell across dozens of sheets.
Is this possible?
Macbook Pro 15", Mac OS X (10.6.4), April 2006