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.
Bookmarks