+ Reply to Thread
Results 1 to 4 of 4

Need Help Populating A Master List For Wedding Invite List

  1. #1
    Registered User
    Join Date
    07-22-2013
    Location
    Texas
    MS-Off Ver
    Excel 2016
    Posts
    8

    Need Help Populating A Master List For Wedding Invite List

    I am working on putting together a list of people I need to send wedding invites to. Sheet 1 in my file is titled "Master List". I have subsequent sheets for my family (Sheet 2), my bride's family (Sheet 3), my friends (Sheet 4), etc. On each of these subsequent sheets I have the headings Last Name, First Name, Spouse/Family, Address, City, State, Zip Code in cells A1:G1.

    I am trying to figure out a way to enter in people's information on these subsequent sheets according to our association (family, friends, etc.) to help ensure that we do not miss anyone, but then have this information automatically populate in alphabetical order on the Master List (Sheet 1). That way when we go to to address invitations we have that one composite list.

    Any help would be much appreciated. I'm spinning my wheels with this thing.

  2. #2
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Need Help Populating A Master List For Wedding Invite List

    As this is in the VBA forum, a VBA solution...

    'MANY SHEETS TO ONE SHEET
    Here's a macro for merging data from multiple sheets into a "consolidation" sheet where the source sheets are the same layout.There's a sample file there, too, to make it easy to try it out. The parts of the code you need to pay attention to or tweak are highlighted in red.

    After copying all the source data into the consolidate sheet, it sorts it. If that's not perfect, you can sort the resulting table any way you wish.
    Last edited by JBeaucaire; 12-27-2019 at 04:36 AM.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    “None of us is as good as all of us” - Ray Kroc
    “Actually, I *am* a rocket scientist.” - JB (little ones count!)

  3. #3
    Registered User
    Join Date
    07-22-2013
    Location
    Texas
    MS-Off Ver
    Excel 2016
    Posts
    8

    Re: Need Help Populating A Master List For Wedding Invite List

    Thanks for the help. This is somewhat what I was looking for. But I do have a question. Is there any way to get the information to auto-populate on the first sheet of a workbook? Our parents (who aren't computer savvy at all) are going to be using the spreadsheet as well and I would like to have a fool-proof way where all they have to worry about is filling out people's information on one of the other sheets. Thanks.

  4. #4
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Need Help Populating A Master List For Wedding Invite List

    After you get the macro working the way you want, it should be stored in a standard code module (Module1) in your workbook.

    Now create a macro that will autopopulate the "main" sheet when it is brought up onscreen. Right-click the main sheet tab and choose VIEW CODE to open the sheet module. Then put in this:

    Please Login or Register  to view this content.

    That should make it more or less fool proof... if they ever go to another sheet and change something, then come back to the main sheet, it will recreate itself instantly for them.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Wedding list
    By irsh in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-14-2013, 07:36 PM
  2. Populating a master list
    By jmprudencio in forum Excel General
    Replies: 1
    Last Post: 12-04-2012, 03:48 PM
  3. Populating a master list from a daily log
    By ryangodammit in forum Excel General
    Replies: 1
    Last Post: 02-25-2012, 12:55 AM
  4. Populating a Master List
    By Petrov in forum Excel General
    Replies: 0
    Last Post: 06-06-2007, 11:21 PM
  5. [SOLVED] Does anyone know of a template for a wedding guest list?
    By HarborMaster in forum Excel General
    Replies: 0
    Last Post: 05-03-2005, 06:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1