Guest List Organization

jesslangen Posted: Mar 30, 2005 02:56 PM

Guest List Organization

Okay Im having issues. I have been using the knot to keep my guet list. Now I know I have a couple listd in there with no address. But why is it when I export to excel it dupelicates some of the names? And it inserts all these rows with no names?

Its really aggriavating me and I just want to figure this out!! SOMEONE PLEASE HELP ME!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

TIA!

MCDO15 Posted: Mar 30, 2005 02:58 PM

Re: Guest List Organization

LIW has a feature to do list guest..and from that, you can do seating charts also

i just made spreadsheed in excel and kept track of things that way

melijane Posted: Mar 30, 2005 02:58 PM

Re: Guest List Organization

DID YOU TRY COPYING AND PASTING INTO A SPREADSHEET? eXCEL IS A PITA!

jesslangen Posted: Mar 30, 2005 03:06 PM

Re: Guest List Organization

Posted by MCDO15

LIW has a feature to do list guest..and from that, you can do seating charts also

i just made spreadsheed in excel and kept track of things that way

the knot also offers table seating and thank you's sent/not sent.

I just cant figure out why when exported its duplicating some of the records! Ugh. this stinks!!!!!!!!!!!!!!!!!!!

ETA: Does anyone else here use the knot for the guest list that could possibly give me some insight on what I am doing wrong? TIA

AnniesSS Posted: Mar 30, 2005 03:09 PM

Re: Guest List Organization

I have an excel SS but I also am using LIW to keep track of guests and the seating chart.

jesslangen Posted: Mar 30, 2005 06:59 PM

Re: Guest List Organization

*bump* for help

jesslangen Posted: Mar 30, 2005 08:10 PM

Re: Guest List Organization

riniko Posted: Mar 30, 2005 08:29 PM

Re: Guest List Organization

If there are duplicates, there is a feature in excel that will only show unique records by doing an advanced filter. Then once you get your filtered list you copy and paste the results into a new workbook.

To get rid of the blank lines, you can sort and then go to the top/bottom and delete the blank lines at one go.

micmar Posted: Mar 30, 2005 08:31 PM

Re: Guest List Organization

I just use excel on my own, it works better for me,but I know what you mean it happened to me when I exported from the knot...it's a little strange, but you have to pick the headings you want to export....

jesslangen Posted: Mar 30, 2005 09:01 PM

Re: Guest List Organization

Posted by micmar

I just use excel on my own, it works better for me,but I know what you mean it happened to me when I exported from the knot...it's a little strange, but you have to pick the headings you want to export....

Thanks for the help! I did select which headings I wanted to export. but for some reason its exporting certain names twice and I can't figure out why Im not sure if its beacuse I set up something wrong....well obviously I did otherwise I wouldnt be in this predicament