tobyspencer
New Member
- Joined
- Mar 25, 2009
- Messages
- 2
Hello.
I'm only a basic user of Excel but I need to produce what has turned out to be a workbook well beyond my scope, so I hope someone will be able to help me along the way.
My workbook will be used to store details of guests attending Christmas dinners at a local conference venue. The details will include their names, their choices of 3 starters, 3 main courses and 3 desserts. Ultimately the data will be exported into Word to allow different sheets to be printed off for the benefit of the different staff involved in the function.
The plan is to send the organiser for each company a workbook with 2 sheets; the first will be a simple sheet where they enter their company's name and the number of guests attending the party. The second sheet will contain a list available menu choices. What I would like to do is create a number of rows on the second sheet with place holder labels like Guest 1, Guest 2 etc but the number of rows created should be taken from the value of the number of guests on the first sheet. The organisers would then replace the place holder labels with the names of their guests and select the choice of starter, main and dessert courses.
Sheet 1: Simple enough. Even I can do this.
Sheet 2: How do I insert a number of rows as defined by the first sheet?
To add to my difficulties, the guest names should be split into groups of 10 as there will always be 10 guests per table.
Is this going to be possible? I apologise for the long post and hope that I've been clear in what I need from you guys.
Regards
Toby
I'm only a basic user of Excel but I need to produce what has turned out to be a workbook well beyond my scope, so I hope someone will be able to help me along the way.
My workbook will be used to store details of guests attending Christmas dinners at a local conference venue. The details will include their names, their choices of 3 starters, 3 main courses and 3 desserts. Ultimately the data will be exported into Word to allow different sheets to be printed off for the benefit of the different staff involved in the function.
The plan is to send the organiser for each company a workbook with 2 sheets; the first will be a simple sheet where they enter their company's name and the number of guests attending the party. The second sheet will contain a list available menu choices. What I would like to do is create a number of rows on the second sheet with place holder labels like Guest 1, Guest 2 etc but the number of rows created should be taken from the value of the number of guests on the first sheet. The organisers would then replace the place holder labels with the names of their guests and select the choice of starter, main and dessert courses.
Sheet 1: Simple enough. Even I can do this.
Sheet 2: How do I insert a number of rows as defined by the first sheet?
To add to my difficulties, the guest names should be split into groups of 10 as there will always be 10 guests per table.
Is this going to be possible? I apologise for the long post and hope that I've been clear in what I need from you guys.
Regards
Toby
