Putting together a print out page from information in workbook.

[macleala]

My wife is a chef and has put together a healthy eating plan for several of her customers. They can choose from a range of foods from a spreadsheet, and these will be delivered ready for them for the coming week.

I have a very limited knowledge of excel but I have managed to put together a spreadsheet that shows the foods available and show the calorie content. A separate box will show the total calories for that day.

The problem I am having is that I want to collate the choices into one print out page so that it will show the day and the food chosen for that day.

I also want to lock all the cells except for where the client selects the quantity of what they would like to order.

I would like the print out sheet to be simple, but to show the day of the week and all the information in columns A, B, C, & D but only if they have selected that item.

I am not very conversant with macros or VBA so I am really struggling with how to this.

I have uploaded the workbook showing how far I have got.

Any help would be very gratefully received.

Thanking you in advance.