V
Vee.Unit
Hey all
Basically my workbook is set up like this..
Name of Company Amount Paid/Recieved
Grouping
Supplier
$100
I basically 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?
Any help is appreciated in advance.
Basically my workbook is set up like this..
Name of Company Amount Paid/Recieved
Grouping
Supplier
$100
I basically 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?
Any help is appreciated in advance.