Kalts
05-18-2012, 02:48 AM
Hello
I need a code to solve my problem. I want to know how I can get information/values from all the cells that matches with criteria and not to sum the values but to create a concatenated list into one cell. Next I want to separate that lastly greated cell into columns, but in a way where the cell data separation into columns is in real time(it will not leave old data on the column row when values in the cell gets shorter and it refreshes or loops so if new information comes to the cell the columns are corrected accordingly and immediately).
I need a code to solve my problem. I want to know how I can get information/values from all the cells that matches with criteria and not to sum the values but to create a concatenated list into one cell. Next I want to separate that lastly greated cell into columns, but in a way where the cell data separation into columns is in real time(it will not leave old data on the column row when values in the cell gets shorter and it refreshes or loops so if new information comes to the cell the columns are corrected accordingly and immediately).