View Single Post
  #1   Report Post  
neilg_cebu neilg_cebu is offline
Junior Member
 
Posts: 1
Default How do I list all sums from sheet1 to sheet2?

Hi All,

As the subject. I would like to list all sums in sheet1 to sheet2. Example:
Sheet1:
Date Amount
01/01/2006 1000
01/01/2006 1500
01/01/2006 500
01/01/2006 800
Total 3800

01/02/2006 2000
01/02/2006 3000
01/02/2006 2000
Total 7000

Sheet2:
01/01/2006 3800
01/02/2006 7000


I want sheet2 to be automatically filled-in with values from sheet1 as illustrated above.

Is it possible to do it? Please help!

Thanks,
Neil