I can't sleep and I'm working on this Excel worksheet. I don' t know much beyond the basics.

Here is what I have:

Sheet 1 lists a customer and under each monthly heading are his charges
Then at the right I have a tally of his monthly charges, how much he has paid (from SUM on Sheet2), and how much owed

Sheet 2 is a list of the same customer and under each monthly heading is how much he paid that month with a running sum at the end of the year that is linked to Sheet 1

I have set it up so that when I enter the customer's name on Sheet 1 it automatically enters on Sheet 2.

Sounds fairly simple right?

Here's the problem:
I need to be able to sort the data alphabetically. If I do a simple sort with just the names it doesn't sort the data. If I highlight the entire table on Sheet 1 and then do a sort by name it sorts the name and the data stays with the name (that is what I want). BUT (here's the problem) it also sorts the names on Sheet 2 but it doesn't link the data with the name. So, after a sort, on Sheet 2 the names are in alpha order, but the data is no longer with the correct name.

Is there any way I can fix this???? I cannot just enter the names alphabetically because the list will increase as the year goes on. I don't really want to separate the two sheets because then I won't be able to have the sums at the end of Sheet 1 (how much owed, how much paid, how much still owed) or at least, I don't think I will.....I'm not sure how to link it if I did that.

If you can help, I sure would appreciate it!! If not, thanks for looking anyway!!
Julie

__________________
"If they are serious about alternative renewable energy sources they should really look into 3 year olds!"

You can copy and paste the information on Sheet 2 onto the end of Sheet 1 and not have the different sheets -- the page breaks.

Then when you go to print, simply do a 'select print area' and print out what you want to be printed.

Maybe that helps?

I have thousands of entries on Sheet 1 and when I go to print out reports, I go into the properties and work with things there. The only time that I use more than one Sheet is when the information on each Sheet is completely unrelated to one another (ie customer reports, inventory, etc)

I hate sheets. I don't use them too often unless it's as Cuthie said, for different things, not related things.

Do you really need to have a 2nd sheet? I would have all that info on one sheet so at a glance you can see what's what instead of clicking thru pages. Can you have monthly headers with subs of monthly charges, paid and owed?

I'm pretty good with excel but as said, I don't use sheets often so I don't know how to solve your problem

good luck

__________________
Proud to say I haven't shopped at a Wal-Mart since Sept 2003

Thanks for trying to help. I really need to have two separate sheets, that's why I set it up that way.
The two sheets are not really related. One is sums of monthly charges, the other is sums of monthly payments. I need to be able to enter all sums of charges on one page and all sums of payments on another page. I'm not printing reports, I need to be able to see at a glance who has charged what and who has paid what, separately. It becomes too cumbersome for the students to have it all on one page (plus I'm hoping to integrate it with a database later.)

Thanks for trying!

__________________
"If they are serious about alternative renewable energy sources they should really look into 3 year olds!"

I am just learning to use Excel and this is where I have been learning:
http://www.usd.edu/trio/tut/excel/

__________________

Life isn't about waiting for the storm to pass
It's about learning to dance in the rain.