Hey group,
I am developing a program for buisness where I have every
buisness expense on sheet one where checks were written. Each check is
written to different sub contractors. I want to list all the subcontractors
on sheet 2 with a space beside each name giving the total to date as to how
much checks has been written to them. I already on sheet one have the simple
sums and subracts and balance working great with no problem, but how would I
program to have each time I write on sheet one to that particular sub
contractor to automatically give total to date on sheet 2 to that particular
subcontracter? I hope I explained what I am wanting. Thanks for the help in
advance as I am sure there is an easy way before I burn midnight oil ;)
Thanx again,

NK

Have you tried using a Pivot Table

--
Message posted from http://www.ExcelForum.com

Hello.... Do not know what you mean by pivot table, ... What I need to know
is how to do a function to direct the function to look on sheet 1? how is
this done?


"MSP77079 " wrote in message
...
Have you tried using a Pivot Table?


---
Message posted from http://www.ExcelForum.com/

Hi,
try copy cell (value you want) of sheet 1 to sheet 2. copy
this down the sheet. it is a link too sheet1
Or it might be easier to create a userform. See some
samples :
http://au.geocities.com/excelmarksway
http:www.geocities.com/excelmarksway

ORRR you cansend me the info and I will do create a
userform for you. Dummy info is okay.



Regards
Mark

-----Original Message-----
Hey group,
I am developing a program for buisness
where I have every
buisness expense on sheet one where checks were written.
Each check is
written to different sub contractors. I want to list all
the subcontractors
on sheet 2 with a space beside each name giving the total
to date as to how
much checks has been written to them. I already on sheet
one have the simple
sums and subracts and balance working great with no
problem, but how would I
program to have each time I write on sheet one to that
particular sub
contractor to automatically give total to date on sheet 2
to that particular
subcontracter? I hope I explained what I am wanting.
Thanks for the help in
advance as I am sure there is an easy way before I burn
midnight oil ;)
Thanx again,

NK


.