Automatic costing of accounting data

[benrsmith]

Hi all.

I am hoping someone can help me with the following:

I have a spreadsheet I use on a monthly basis (unable to attach as at work) for recording Purchase Ledger spend across several business units and costing it to the relevent column (ie parts, repairs, site maint etc).

I receive data from the B.U's in the form of an accounting package report (usually 3 columns: Supplier code, Supplier name and Month's Turnover)

What I am wanting to do is paste the data into my sheet and have it automatically sort each supplier's turnover into the correct column based on the supplier name (ie turnover for supplier called KRT will automatically be copied accross to the column for Tyres, Autosmart to the column for Valeting etc) Also the ability to highlight any unknown values so I can add them to whatever list or table such a function would use, would be very handy indeed.

In a previous job I used to use a spreadsheet that did this for imported bank data to produce a cash flow analysis so I know it is possible, I just can't for the life of me remember how it worked! (It was created by the company IT manager and Excel guru)

Thanks very much,

Ben

[benrsmith]

Found a way to upload the sheet I am using.

Ben