software

Hi

I hope someone can help me with a difficult problem. I have a
spreadsheet with the following data below that will eventually have 60
plus depots:
Date Selected Date Cleared Depot Bank $5 $10
$20 Total
21/4/06 Altona ANZ 500
1000 6000 7500
CBA
1500 2000 6000 9500
NAB
500 1000 5000 6500

20/4/06 Penrith ANZ 600
2000 3000 5600
CBA
500 1000 2000 3500
NAB
1000 2000 3000 6000

What I am trying to do is sum this data into another sheet as is below

ANZ CBA NAB WBC

20/4/06 500 1000 2000 3000
21/4/06 1000 2000 3000 4000
22/4/06 3000 4000 5000 6000

What I am requiring is that when data is entered for the date selected
for any depot , the total for that bank goes under that date and
continues and then finishes when the date cleared is entered.
I hope that is clear.

Thanks for your help--
david72
------------------------------------------------------------------------
david72's Profile: www.excelforum.com/member.php...foamp;userid=7980
View this thread: www.excelforum.com/showthread...hreadid=535383I think you need to explain how you get from the data to the results, it is
not obvious where the link is. What do $5, $10,$20 all mean, and where is
the WBC data?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;david72quot; gt; wrote in
message ...
gt;
gt; Hi
gt;
gt; I hope someone can help me with a difficult problem. I have a
gt; spreadsheet with the following data below that will eventually have 60
gt; plus depots:
gt;
gt;
gt;
gt; Date Selected Date Cleared Depot Bank $5 $10
gt; $20 Total
gt; 21/4/06 Altona ANZ 500
gt; 1000 6000 7500
gt; CBA
gt; 1500 2000 6000 9500
gt; NAB
gt; 500 1000 5000 6500
gt;
gt; 20/4/06 Penrith ANZ 600
gt; 2000 3000 5600
gt; CBA
gt; 500 1000 2000 3500
gt; NAB
gt; 1000 2000 3000 6000
gt;
gt; What I am trying to do is sum this data into another sheet as is below
gt;
gt; ANZ CBA NAB WBC
gt;
gt; 20/4/06 500 1000 2000 3000
gt; 21/4/06 1000 2000 3000 4000
gt; 22/4/06 3000 4000 5000 6000
gt;
gt; What I am requiring is that when data is entered for the date selected
gt; for any depot , the total for that bank goes under that date and
gt; continues and then finishes when the date cleared is entered.
gt; I hope that is clear.
gt;
gt; Thanks for your help
gt;
gt;
gt; --
gt; david72
gt; ------------------------------------------------------------------------
gt; david72's Profile:
www.excelforum.com/member.php...foamp;userid=7980
gt; View this thread: www.excelforum.com/showthread...hreadid=535383
gt;