Wedding Planner

[McKnze21]

Hi All,

Hope all are well!!

Looking for a little assistance with an Excel spreadsheet I am creating for a friend to organise her wedding. I have a tab for a seating plan from the guest list which is on another tab and I'd like if possible for the names to automatically be placed in some sort of table layout??

Also, I have a column on the guest list tab next to the names which I want to show the table & seat number. Is there a formal or way of having Excel search the seating plan and then for the table and seat that the name corresponds to, then enter that result in to the column on the Guest tab?

I have attached spreadsheet for you all to see. Any advice on how to make this so much better is welcomed!!

THanks!!

 

[Fluff]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Help: Wedding Planner
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[Fluff]

The table plan would need to be done manually, but the the columns to the right & the day sheet can be done with formulae. Is that what you want?

 

[McKnze21]

The table plan would need to be done manually, but the the columns to the right & the day sheet can be done with formulae. Is that what you want?

Yeah pretty much

 

[Fluff]

Ok, for col N onwards you can use something like

MacBride Wedding Rev1.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z
4														Table 1	Table 2	Table 3	Table 4	Table 5	Table 6	Table 7	Table 8	Table 9	Table 10	Table 11	Table 12	Table 13
5	a	k	f										Seat 1	a
6	b		g										Seat 2	b
7	c	Table1	h										Seat 3	c
8	d		i										Seat 4	d
9	e	l	j										Seat 5	e
10													Seat 6	f
11													Seat 7	g
12													Seat 8	h
13													Seat 9	i
14													Seat 10	j
15													Seat 11	k
16													Seat 12	l
Seating Plan

Cell Formulas
Range	Formula
N5:N9	N5	=IF(A5="","",A5)
N10:N14	N10	=IF(C5="","",C5)
N15	N15	=IF(B5="","",B5)
N16	N16	=IF(B9="","",B9)

And on the Day sheet in C2 filled down

=IF(A2="","",INDEX('Seating Plan'!$N$4:$Z$4,AGGREGATE(15,6,(COLUMN('Seating Plan'!$N$4:$Z$4)-COLUMN('Seating Plan'!$N$4)+1)/('Seating Plan'!$N$5:$Z$16=A2),1)))

and in D2

=IF(A2="","",INDEX('Seating Plan'!$M$5:$M$16,AGGREGATE(15,6,(ROW('Seating Plan'!$M$5:$M$16)-ROW('Seating Plan'!$M$5)+1)/('Seating Plan'!$N$5:$Z$16=A2),1)))

 

[McKnze21]

Thanks for this but sorry, I don't think that is doing quite what I after...

First of all, on the seating plan tab I'd like drop down boxes on seats around tables so I can pick and choose, play around with choices at tables (So Removing the name from the list if they have already been chosen so not to duplicate) and then as they are picked, the table to the side is automatically filled.

Then as a result of this table being filled, I'd like the Table & Seat columns on the Day tab to be populated accordingly with without Table and seat number that person is.

Hope this maybe explains this better! Thanks!

There is an attachment of the spreadsheet on this forum post: Help: Wedding Planner

 

[Fluff]

First of all, on the seating plan tab I'd like drop down boxes on seats around tables so I can pick and choose, play around with choices at tables

You already have that in place.

Then as a result of this table being filled, I'd like the Table & Seat columns on the Day tab to be populated accordingly with without Table and seat number that person is.

That's what the formulae I suggested do.

 

[McKnze21]

You already have that in place.

That's what the formulae I suggested do.

My apologies... I have just discovered this. Thanks!

I had to put the top table row as a column before Table 1 as wan't sure you to make it look for two different areas in the one formula?

 

[Fluff]

Hadn't noticed the Top Table, but yes putting that as an extra column, makes it a lot easier than keeping it as a separate row.

 

[McKnze21]

I

Hadn't noticed the Top Table, but yes putting that as an extra column, makes it a lot easier than keeping it as a separate row.

If there is no entry yet then the cell on 'Day' tab returns #NUM!, is there anyway for it to return like "TBC" or even just blank?