Need to unravel Spreadsheet data.

I have data like this:

AABB17312981.9240730LMCGT4008AABB3001488340815LMCGT4009AABB3001980940815LMCGT4010AABR2765002840930BAF4000AABR103000040730BCLM4006AABR6002131840815BDA4000AABR54616052.440730BCEA4008

AA is the vendor, next col. is the division, then QTY & $amt. I would like to create a second
spreadsheet that would have a combined Vendor - DIv total going accross in 2 week
intervals, which can be taken from the date. This date is the next 2 week interval point of the
original date, which happens to be expected import arrival date. SO I would want going accross a total
QTY ( I think $ are not used for now, not is the last column), then broken down by two week periods, e.g.
2/15/04 2/28/04 etc.... then totals for those columns.
THen to do the same for Vendor only as a separate section and finally for Division only.

Is it possible/easy to do this in Excel VBA ?

Thanks,
Phil

Hi

I don't understand the problem.
Expalin it more clearly with example, i will try to help u.

Thanks
Sen