Can Excel defy accounting programs in this issue?

[gaftalik]

Hello ,

If in my sheet named "Entries" i list all my transactions,what will be the formulas in sheet "Tom"or "John" under D12 &D19;E12&E19;F12&F19 whereas each time the word tom or john in the explanation column in"Entries" appears, the respective row data from under Date,Explanations and Debit values will be copied accordingly to each person's sheet name,if not it remains blank !
Actually,i have many persons sheets..

Could Excel solve such a problem or am i dreaming ?

Book1
	C	D	E	F	G	H
3
4		Date	Explanations	Place	Debitvalue
5
6		22.02.2004	paidtojohnasloan	1	100
7		22.02.2004	cashtotompartofsalary	1	23
8		22.02.2004
9		Entries
10
11		Date	Explanations	Debitvalue
12		22.02.2004	cashtotompartofsalary	23
13
14
15
16		Tom
17
18		Date	Explanations	Debitvalue
19		22.02.2004	paidtojohnasloan	100
20
21
22
23		John
24
Sheet1

 

[gaftalik]

Thank you Yogi that worked , but i am still figuring why it copied tom also !
do you think it will recopy all the data each time i have to update the records?

 

[Yogi Anand]

Thank you Yogi that worked , but i am still figuring why it copied tom also !
do you think it will recopy all the data each time i have to update the records?

Hi gaftalik:

I don't know what you mean. The Entries sheet of course contains the entire data including that for John and Tom, and whoever else you had recorded a transaction for. But when you filter the records in John's sheet, only John's records should show up.

Please check your data in Entries sheet, and John's sheet, and then post back -- and then let us take it from there.