joshatse
05-03-2007, 08:43 PM
Hi,
I have a spreadsheet and would like to merge the columns.
1 A B C D
2 xxx yyy xxxx
3 Data1 Data2
4 1 2
5 2 3
The macro should look for the String Data2 and merge all the columns from A4-B4 to end of the spreadsheet and store it in C4 onwards. The Result should as shown in BOLD.
1 A B C D
2 xxx yyy xxxx
3 Data1 Data2 MergedData
4 1 2 12
5 2 3 23
Thanks in Advance :)
I have a spreadsheet and would like to merge the columns.
1 A B C D
2 xxx yyy xxxx
3 Data1 Data2
4 1 2
5 2 3
The macro should look for the String Data2 and merge all the columns from A4-B4 to end of the spreadsheet and store it in C4 onwards. The Result should as shown in BOLD.
1 A B C D
2 xxx yyy xxxx
3 Data1 Data2 MergedData
4 1 2 12
5 2 3 23
Thanks in Advance :)