![]() |
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