Excel question

I am trying to make a list of people that I have to book for a show.I want to have a separate sheet for each show (ex. July 28, 30, etc.) What I want to do is type in their info (name, e-mail, phone #s, etc.) and then type in the dates of the shows they are attending and have it so it automatically sorts all their info on to each day's sheet. Does anyone now how to do this? i would greatly appreciate to learn how because it would save me a LOT of time.

is there some sort of calendar program that would do the same thing? i.e. If I put the names in the address book and use that as a master list

If I'm understanding you correctly, you could probably set this up in Access. All you'd need is a table for putting in the various information and then a query for bringing up individuals for a specific date. Is that what you want or am I missing the point?

yes...

Now i have a new question that is more basic. I want to sort it by their last name. However, when I try to do this it says "this operation requires the merged cells to be identical in size." what am I doing wrong?

If you're not tied to Excel, Access can automatically build an event management db for you with the type of reports I think that you are looking for.

If you are tied to Excel, attached is a spreadsheet that is an example of what it sounds like you are trying to do.

Enter the attendees on the data sheet and flag yes to any day they are attending. Then navigate to the sheet. Turn off auto filtering if its turned on then sort the list and reapply the autofilter for non-blanks. This should give you a list for just that day.

It is ugly. A better solution would use Excel VBA or Access as mentioned previously.

To your second question, you have formatted two or more cells as merged. Sorting will not work across merged cells. Change the cell format or don't sort the merged cells.

i have a new problem now (i need to take a course in excel in think) whenever I click on an e-mail, it won't let me edit it..it just goes to my yahoo acct to send an e-mail....however, all i want to do is change the address....

Right click on the email address and choose "Edit Hyperlink."

I hate how Excel handles URL's and Email addresses.

- trs

Or, with the cell selected (via keyboard), press Ctrl+K.

I agree that it is annoying. Does anyone know how to tell Excel whether you want a clicked link to open in a new window or an existing window?