Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
populating monthly costs in excel sheets...
Hi,
I have a table with the data laid out as follows ID EOMStart_Date Freq Amount 1 30/04/2009 12 12000 2 31/05/2009 3 12000 2 31/08/2009 3 15000 3 30/04/2009 1 12000 3 31/05/2009 1 12000 3 30/06/2009 1 12000 4 31/05/2009 12 12000 5 30/06/2009 12 12000 The idea is to ascertain the total month cost across each contractID, For eg.. ID Apr-09 May-09 Jun-09 Aug-09 Sep-09 oct-09 Nov-09 .... to Mar-09 1 1000 1000 1000 1000 1000 1000 1000 ..... 1000 2 0 4000 4000 5000 5000 5000 5000 ..... 5000 3 12000 12000 12000 12000 12000 12000 12000 ..... 12000 4 0 1000 1000 1000 1000 1000 1000 .... 1000 5 0 1000 1000 1000 1000 1000 1000 ..... 1000 Total 13000 19000 19000 20000 20000 20000 20000 .... 20000 I have about 30000 rows of contracts, & I'm sure there's an easier way of doing this besides endless cups of coffee & a very sore back after hundreds of hours of manual typing..... Any help sincerly appreciated! Neil |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel sheets not populating | New Users to Excel | |||
populating sheet with data from other sheets | New Users to Excel | |||
Populating a main and 'regional' sheets | Excel Programming | |||
populating from sheets -- and PLEASE don't tell me I need VB! | New Users to Excel | |||
populating sheets based on data from parent sheets | Excel Discussion (Misc queries) |