Ziad
03-29-2017, 02:47 AM
Good morning everyone,
I am a complete newbie in Excel VBA programming, and I am not sure I'll be able to write code myself...
To begin with, here is what my tables look like, more or less. I have loads of data, with this set up. Data is spread on several sheets.
A
B
C
1
AAAAAAA
10 Oct 206
bla bla bla bla
2
bla bla bla bla
3
AAAAAAA
10 Oct 206
bla bla bla bla
4
bla bla bla bla
5
AAAAAAA
10 Oct 206
bla bla bla bla
6
bla bla bla bla
7
bla bla bla bla
8
AAAAAAA
10 Oct 206
bla bla bla bla
9
bla bla bla bla
What I want to do is clean up all this mess:
copy text from C2 to end of C1, separated with a blank space. These are sentences, and I want the full sentence in one cell
delete row 2 once C2 is empty
copy all data to a new sheet, so that I hav everything on a single sheet.
Considering that I have cases where I want to copy C6 to end of C5, then C7 to end of C5, and delete both rows 6 & 7.
I have found a looong workaround through a formula : D1=IF(B1<>"";C1&" "&C2;"")
It works, but that would be too long to use with the entire documents.
I have looked up some VBA coding, but I have to say that whatever I try, it remains foreign language to me, and I can't get my head round it.
Any help is welcome, and will receive my eternal gratitude in the form of a huge smile to my screen.
Thanks.
I am a complete newbie in Excel VBA programming, and I am not sure I'll be able to write code myself...
To begin with, here is what my tables look like, more or less. I have loads of data, with this set up. Data is spread on several sheets.
A
B
C
1
AAAAAAA
10 Oct 206
bla bla bla bla
2
bla bla bla bla
3
AAAAAAA
10 Oct 206
bla bla bla bla
4
bla bla bla bla
5
AAAAAAA
10 Oct 206
bla bla bla bla
6
bla bla bla bla
7
bla bla bla bla
8
AAAAAAA
10 Oct 206
bla bla bla bla
9
bla bla bla bla
What I want to do is clean up all this mess:
copy text from C2 to end of C1, separated with a blank space. These are sentences, and I want the full sentence in one cell
delete row 2 once C2 is empty
copy all data to a new sheet, so that I hav everything on a single sheet.
Considering that I have cases where I want to copy C6 to end of C5, then C7 to end of C5, and delete both rows 6 & 7.
I have found a looong workaround through a formula : D1=IF(B1<>"";C1&" "&C2;"")
It works, but that would be too long to use with the entire documents.
I have looked up some VBA coding, but I have to say that whatever I try, it remains foreign language to me, and I can't get my head round it.
Any help is welcome, and will receive my eternal gratitude in the form of a huge smile to my screen.
Thanks.