ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Linked sheets with sequencial order in 2ツコ Sheet (https://www.excelbanter.com/excel-discussion-misc-queries/71554-linked-sheets-sequencial-order-2%C2%BA-sheet.html)

Micos3

Linked sheets with sequencial order in 2ツコ Sheet
 
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?


All times are GMT +1. The time now is 10:42 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com