Thanks Gord....I will check out the site and see if there are some easy
options for my dilema....lol Have a great day....
"Gord Dibben" wrote:

I think a Pivot Table may be what you need.

See Debra Dalgleish's site for excellent assistance with PT's

http://www.contextures.on.ca/tiptech.html




On Wed, 28 Feb 2007 10:42:08 -0800, Keepitsimple72
wrote:

Hi everyone...My name is Traci..........I have a question regarding excel if
someone could help I would greatly appreciate it...

I started a new job about 2 months ago and we are using excel...The page has
been set up into columns for; address, file number, fee amount, and then the
GST section which gets added in automatically, and then who the job is going
to....it has been set up this way for about 4 years. We are using the same
page on excel as 4 years ago so you can scroll up and get all the info from
2002, etc....My question is the receivable total at the bottom shows all the
combined totals owing from all the years so it shows a HUGE amount owing to
us for all those years combined....How do I separate each year to provide a
different amount for receivables for each year.....Do I just add in extra
spaces to separate the years or how would I go about separating the yearly
totals? Please help me as I really need to get this done ASAP....PLEASE help
if you can...Thank you very much from someone desparatly needing
assistance....lol