Re: Problem with datatable
Just use a formula in Sheet2 B2 like: =(Sheet1!A2&Sheet1!A3&Sheet1!A4)
Make sure A2 - A4 are formatted as text.
Problem with datatable
I have a problem concerning writing data from an excel sheet to another excel sheet. The problem is that I need to write the contents of multiple cels in one excelsheet to one cel in another excel sheet.
So basically I need to write the contents of for example cels A2, A3 and A4 to one cel in the other excel sheet for example B2.
The problem is that if I try to append them one at the time, that the contents of B2 is always overwritten.
I tried to store the contents of A2, A3 and A4 in a variable and write this to the other excel sheet, but sometimes it concerns to many cels ... the variable can't store all lines.
So to summarize I need a way to append the data to a cel. If anyone has any idea how to solve this?