How can I automatically copy some corresponding cells from some rows in a columnin to different rows inline with an identicall cell from another column?

 

I have a table where data from rows in A column has corespnding descriptions/ values in the same rows, in B,C and D columns.
If data from column F is found in any row in column A, than all data contained in corresponding ROW value 1,2.3  to be automatically copied in the value 11, value 22 and value 33 columns, at the coresponding cells.
Example1: Data from E3 cell is found in A5 and A 11 cells. I want B5 automatically copied in F3 cell, C5 in G3 and D5 in H3.
Example2: Data from E5 cell is found in A8 cell. I want B8 automatically copied in F5 cell, C8 in G5 and D8 in H5.
Example3: Data from E7 cell is found in A9 cell. I want B9 automatically copied in F7 cell, C9 in G7 and D9 in H7.
DATA 1 value 1 value 2 value 3 DATA 2 value 11 value 22 value 33
111 333 444 555 114 I want data from B5 to be automatically copied here I want data from C5 to be automatically copied here I want data from D5 to be automatically copied here
112 334 445 556 188
114 336 447 558 117 I want data from B8 to be automatically copied here I want data from C8 to be automatically copied here I want data from D8 to be automatically copied here
115 337 448 559 118
116 338 449 560 119 I want data from B9 to be automatically copied here I want data from C9 to be automatically copied here I want data from D9 to be automatically copied here
117 339 450 561 149
119 341 452 563 122
120 342 453 564 88
114 336 447 558 112
123 345 456 567 114 I want data from B5 to be automatically copied here I want data from C5 to be automatically copied here I want data from D5 to be automatically copied here
124 346 457 568 35
125 347 458 569 36
127 349 460 571 37
128 350 461 572 38

By: Sergiu

Leave a Reply

Your email address will not be published. Required fields are marked *