I'm making a db with 1 linked sheet (K), connected to an principal one (P1).
I want to do this:
When the word "K" is tiped in P1, in row C, to copy that line to sheet K,
then when i tipe again the word "K" in P1, in row C, i'll copy that line (or
just some data that i need of that line) for sheet K for line after the first
one. And then so on, and so on....
I make an example below.
If i wanted just the data with no order i could do in gain
=if('P1'!C2="K";'P1'!D2;"")
and in Lost
=if('P1'!C2="K";'P1'!E2;"")
But i want that in sheet K data appears all sequencially and by order, like
i show in example. The line 1,3 and 6, of sheet P1, appears in sheet K, in
line 1,2,3.

Sheet P1
A B C Gain Lost
1 12-05 Suplier K 10‚¬ 0
2 12-05 Suplier Y 0 5‚¬
3 13-05 Suplier K 0 15‚¬
4 13-05 Suplier W 7,5‚¬ 0
5 14-05 Suplier Y 8‚¬ 0
6 15-05 Suplier K 6 0
7 15-05 Suplier W 0 9‚¬

in Sheet K these data will be recorded:
Sheet K
A B Gain Lost
1 12-05 Suplier 10‚¬ 0
2 13-05 Suplier 0 15‚¬
3 15-05 Suplier 6‚¬ 0

How can i do this?