NEED HELP WITH EASY MACRO COPY PASTE/EXCEL
Closed
SCHRAMBOW
-
Mar 7, 2009 at 05:53 PM
darwinchin Posts 2 Registration date Thursday October 1, 2009 Status Member Last seen October 1, 2009 - Oct 1, 2009 at 11:50 PM
darwinchin Posts 2 Registration date Thursday October 1, 2009 Status Member Last seen October 1, 2009 - Oct 1, 2009 at 11:50 PM
Related:
- NEED HELP WITH EASY MACRO COPY PASTE/EXCEL
- Kodak easy share download - Download - Image viewing and management
- Spell number in excel without macro - Guide
- Roxio easy media creator - Download - CD and DVD
- Easy anti cheat download - Guide
- Excel marksheet - Guide
2 responses
darwinchin
Posts
2
Registration date
Thursday October 1, 2009
Status
Member
Last seen
October 1, 2009
1
Oct 1, 2009 at 11:50 PM
Oct 1, 2009 at 11:50 PM
Hi everyone,
I have just started learning Macro, but now i have a problem and hope you can help me with. Thanks in Advance.
I am working on a dataset which looks like this (its a stock volatility series)...
A B C D E F.....
1 1 1 1 1 1
2 2 2 2 2 2
3 3 3 3 3 3
4 4 4 4 4 4
5 5 5 5 5 5
. . . . . . . .
. . . . . . . .
. . . . . . . .
I would like to copy all the value in Column B and paste them to the end of Column A, and then copythe entire column C to the end of column A, and then copy and paste column D to end of column A and so on. Hence, i would like column A to have all the data from all columns.
The problem is i have 200 columns and 830 rows for each column to work with, let alone 15 other spread sheets, if I am to copy and paste them accordingly. I hope you guys can help me in this respect.
thanks much in advnace
I have just started learning Macro, but now i have a problem and hope you can help me with. Thanks in Advance.
I am working on a dataset which looks like this (its a stock volatility series)...
A B C D E F.....
1 1 1 1 1 1
2 2 2 2 2 2
3 3 3 3 3 3
4 4 4 4 4 4
5 5 5 5 5 5
. . . . . . . .
. . . . . . . .
. . . . . . . .
I would like to copy all the value in Column B and paste them to the end of Column A, and then copythe entire column C to the end of column A, and then copy and paste column D to end of column A and so on. Hence, i would like column A to have all the data from all columns.
The problem is i have 200 columns and 830 rows for each column to work with, let alone 15 other spread sheets, if I am to copy and paste them accordingly. I hope you guys can help me in this respect.
thanks much in advnace
Hope this helps!
Sub SeparateColumn()
Dim SepInfo As Range
Set SepInfo = Columns(1)
SepInfo.TextToColumns Destination:=Range("B1"), DataType:=xlDelimited, Space:=True
End Sub
Sub SeparateColumn()
Dim SepInfo As Range
Set SepInfo = Columns(1)
SepInfo.TextToColumns Destination:=Range("B1"), DataType:=xlDelimited, Space:=True
End Sub
thank you so much,
you have no idea how much you have helped me and how much time you have saved me replying right away.
i would love to learn how to know how you did this and the language of these scripts/macro's. For looking at these macro's for the first time, i don't have any understanding of this language but would love to know where to start learning this.
Again, Thanks SO MUCH, for taking a bit of your time for helping me out.
Thank you Thank you!!
Corey
you have no idea how much you have helped me and how much time you have saved me replying right away.
i would love to learn how to know how you did this and the language of these scripts/macro's. For looking at these macro's for the first time, i don't have any understanding of this language but would love to know where to start learning this.
Again, Thanks SO MUCH, for taking a bit of your time for helping me out.
Thank you Thank you!!
Corey
