Hi all,
I need help with a VBA code. I would like to rearrange data in my spreadsheet . Right now it is easy because I have a unique sample name in each row. After a software update the result file changed.
1. I need to copy the cities (green)from the city column to the title in the result tab (because it may change in number and order from result file to result file).
2. With the sample name on the front in the result tab.
3. Then transpose the values underneath.
I’m sorry just can wrap my head around it.
Thanks in advance for your help.
I need help with a VBA code. I would like to rearrange data in my spreadsheet . Right now it is easy because I have a unique sample name in each row. After a software update the result file changed.
1. I need to copy the cities (green)from the city column to the title in the result tab (because it may change in number and order from result file to result file).
2. With the sample name on the front in the result tab.
3. Then transpose the values underneath.
I’m sorry just can wrap my head around it.
Thanks in advance for your help.