View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
nigerobinson nigerobinson is offline
external usenet poster
 
Posts: 5
Default Formatting Data Lists

When I import data from my accounts package it is not lined up against
previous imported data. How can I line the rows up so I can subtract one
column away from another.

A B C D E F G H
110 250 Wages 100.00 110 250 Wages 100.00
120 310 Advert 564.00 125 564 Misc 654.00
125 564 Misc 654.00 130 425 Training 854.00

A is the Cost centre, B is the Expense code, C is the detail and D is the
Amount.