PDA

View Full Version : Pull data from one table to another



Lopina1974
10-11-2019, 06:19 AM
First of all, best regards to everybody

I have some issue
I have table looking like this

Material name Machine 1 Machine 2 Machine 3
Material 1 Prio1 Prio1 Prio2
Material 2 Prio 1 Prio2
Material 3 Prio1

What I want to do, when inserting material name in cell, if possibly get name of machine names sorted by priorities

Looking like this

Material name Prio1 Prio2 Prio3
Material 1 Machine 1 Machine 2 Machine 3
Material 2 Machine 2 Machine 3
Material 3 Machine 1

Please if anybody have some suggestions. Is there some function or code.


Thanks anyway!!