Help with Excel

Welruc

Hi all, some help needed.

I'm looking for an excel sheet that can create a menu, im trying to use a list of words which when selected will place the description onto another page for printing.

I dunno if ive explained that well enough but its for a hotel and to be used to generate the food menus, basically i need a list on onr sheet where you can tick the box and this will produce the menu for printing on another.

Im not overly confident with excel and i dunno if maybe im over complicating this but if i could get a few pointers or if any of ye have anything similar that i can edit i would be grateful.

namenotavailablE

Not sure but it sounds like a sort of 'mail merge' type project.

The idea would be as follows:

1. Use Excel to enter a list of menu items- maybe in a column in Sheet 1. You could have the word 'TRUE' or 'FALSE' beside each menu item which you could set yourself each time you want to vary the menu.

2. On another Excel worksheet, Sheet 2, you would enter column headings such as 'Menu item 1', 'Menu item 2' etc in row 1. In row 2, you would use formulae to pick up the menu text linked to each TRUE text appearing in Sheet 1.

3. You'd then create a template in Word which allows you to print off the text displayed in row 2- you'd need to know how to set up such a template.

bridster007

Just use one sheet.
Add a Y/N column for each item and use a filter for Y.