I am creating a Wedding Guest List in Excel and want to know how I can rinformat

Question

I am creating a Wedding Guest List in Excel and want to know how I can rinformation from multiple worksheets to one master sheet automatically. For example, I have a worrksheet for the Groom's Family, one of the Bride's Friends, etc. This way we can input and keep track of each perrson's guests in an organized manner. I! basically want to create a master guest list, with the same layout, thatt aautomatically populates from whatever we type into the more specific sheets (names, addresses, etc.). Any suggestions????

Explanation / Answer

This is my suggestion and I am sure someone will come along and say no! no! no! to complex waste of effort but here goes.

Make sure to make enough rows for suddenly added people. Sometimes the people invited want to bring guest: Husbands, wives, boyfriends, girlfriends, young children; that you don't expect.

If setup correctly you wwon't have to retype. as people are added to one this the Master list will Update.

You can alwayss sort Groom's and Brides List by last name (but you want to select the entire list) and thee Mater list should be updated sorted by Last Name, Or you can Choose say City or statee or whatever. In any event if you sort it correctly itw will show up sorted on Master list as weell.

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.