Income/Outgoings Spreadsheet

[stuartgb100]

Looking for a spreadsheet that will help my daughter keep track of her monthly expenditure.
I'm planning as follows:
Col B will list a description of the item (eg petrol)
Col C will have the value
In Col D, she will enter an 'identifier' (a number between 1 and 5),
which will be used to sort the data.
So,for example, 1 could be critical items (such as rent, paying off a loan etc) whereas 5 could be
something much less critical (such as buying yet another MacDonalds !).

What I'd like to happen is that when she enters 1 into col D, the adjacent value in col C is copied to col F (same row).
If it were 2, then the value would be copied to col G (same row), etc. etc.

I think this can be done with cell formulae, but I don't want the sheet full of '0.00's everywhere !

Any help much appreciated.
Many thanks.

 

[FormR]

Hi, something like this maybe:

Book1
	A	B	C	D	E	F	G	H	I	J
1
2			10	1		10
3			5	3				5
4			19	5						19
5			25	4					25
6			44	2			44
Sheet1

Cell Formulas
Range	Formula
F2:J6	F2	=IF($D2=COLUMNS($F2:F2),$C2,"")

 

[stuartgb100]

Perfect. Many thanks.
Apologies for the delay in replying.
Cheers.