Sortin my messy excel sheets!

[Vee.Unit]

Hey all

Basically my workbook is set up like this..

Name of Company Amount Paid/Recieved
Supplier $100

I want to set up my workbook so excel recognises the name of
the company (e.g. Supplier), and then automatically places the amount
($100) into a category. So far I have been doing this manually but
surely there is a way for excel to this automatically?

Surely theres a way usin VBA or smething.. any guidance will be <3'd
and save me a LOT of time doin it manually..

Any help is appreciated in advance

 

[Don Guillett]

You could use a simple VLOOKUP formula (look in the help index) or FIND in
vba help index.
Your detail leaves a lot to be desired.

 

[Gord Dibben]

You may want to have a dropdown list for the company names and VLOOKUP for
filling the amount paid column from a table.

See Debra Dalgleish's site for more on VLOOKUP and Data
Validation lists for entering the choices.

http://www.contextures.on.ca/xlFunctions02.html

http://www.contextures.on.ca/xlDataVal01.html

Note the section on using DV lists from another worksheet by naming the list.


Gord Dibben MS Excel MVP