+ Reply to Thread
Results 1 to 3 of 3

Need help designing a lookup function for wedding invites

  1. #1
    Registered User
    Join Date
    12-06-2016
    Location
    Missouri
    MS-Off Ver
    2013
    Posts
    2

    Need help designing a lookup function for wedding invites

    Hey guys,

    I've got a list of attendees and their addresses. I'm going to be hand-writing the envelopes and doing some calligraphy. What would make my life easier is if the information wasn't displayed as

    "A1, B1, C1, D1"

    But instead

    "A1
    B1
    C1
    D1"

    I can do that much just by referencing the cells, but I can't figure out a way to move each cell down a row without manually changing all the X1's to X2's.

    Anyone have any ideas?!

    Thanks!

  2. #2
    Valued Forum Contributor
    Join Date
    11-02-2016
    Location
    NY
    MS-Off Ver
    2010
    Posts
    459

    Re: Need help designing a lookup function for wedding invites

    Use each ROW as a record ( A1 B1 C1 D1)...save yourself some headaches and use MS Word labels or Access. In fact, if you look up some old access database books there was a Wedding Planner program in it (perhaps version 2000 or 2003? can remember). I like Word, because it already had templates to match popular labels (Avery and others). Congrats! [ word has/had a wizard to assist in creating labels that it would 'pull' from Excel. ]

  3. #3
    Registered User
    Join Date
    12-06-2016
    Location
    Missouri
    MS-Off Ver
    2013
    Posts
    2

    Re: Need help designing a lookup function for wedding invites

    I didn't even think about using an alternate Office program! I'll check out both Word and Access, thanks!

+ 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. Replies: 1
    Last Post: 10-22-2015, 12:30 PM
  2. Replies: 2
    Last Post: 02-06-2014, 01:17 AM
  3. Outlook Meeting Invites - easiest way to add attendees
    By Amphibia07 in forum Outlook Formatting & Functions
    Replies: 0
    Last Post: 07-24-2013, 08:11 AM
  4. Wedding Dance ... Who is it?
    By bambino_32 in forum The Water Cooler
    Replies: 3
    Last Post: 01-13-2011, 09:03 AM
  5. Trouble Designing a Lookup
    By Kevin in forum Excel General
    Replies: 6
    Last Post: 05-23-2006, 06:15 PM
  6. Free GMail Invites!
    By agarwaldvk in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-22-2005, 11:57 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