Excel Checklist

Re: Excel Checklist

• Beachy730 member

  

  September 2010

  I did one, but I'm not savvy enough to figure out how to clear my info and send it for you.  I'll just break it down for you.  I did one spreadsheet file, but had 4 different sheets to it, and each had different columns.  I would copy and paste the guest list to each sheet.  Also, I had the guest list broken into groups, like my family, H's, friends, family friends, etc.  I had a seperate count after each group which helped me keep track easier. 
  
  1st sheet columns - Guest, address, RSVP and how many, and meal selected.  I also color coated the RSVP column as it came in.  Green was yes and all the people invited were coming, red was none were coming, and yellow was some of the invited were coming.  Helped my count. 
  
  2nd sheet columns - Person invited to shower (if anyone), RSVP, gift received, TY sent
  
  3rd sheet columns - wedding gift, TY sent
  
  4th sheet - I used this one to play around with the seating chart possibilities.
  
  I hope this helps.  It was incrediby helpful to me, and kept me insanely organized.  If you need more help let me know and I can email you my list or something. 

  

  Report0 Reply
• Andriamckaig member

  

  October 2010

  Thank you so much!

  Report0 Reply