Search : in
By :

NEED HELP WITH EASY MACRO COPY PASTE/EXCEL

Last answer on Oct 2, 2009 4:50:21 am BST SCHRAMBOW, on Mar 7, 2009 10:53:15 pm GMT 
 Report this message to moderators

Hello,
JUST GETTING STARTED WITH MACRO'S,

GOT TO BE EASY FOR ANYONE, BASIC,

I HAVE A COLUMN A, THAT HAS DATA IN ONE COLUMN, SEE BELOW EXAMPLE SHEET, HOW CAN I SEPERATE EACH ITEM OF DATA AND PUT INTO COLUMNS TO RIGHT (SEPARATE OUT THE DATA FROM ONE COLUMN AND PUT EACH SEPARATE ITEM INTO ITS OWN COLUMN TO RIGHT OF IT EXAMPLE B,C,D,E).
I CAN DO WITH MACRO RECORDING ON ONE ROW, BUT I CAN'T FIGURE OUT HOW TO MAKE IT GO TO THE NEXT ROW (RE: COPY THE MACRO TO HUNDREDS OF THE SAME ROW I JUST DID?)

14828 02/18/09 5416.88 5417 5416.88
14829 02/18/09 5373.48 5373 5373.48
14870 02/23/09 5811.03 5811 5811.03
14871 02/23/09 5633.84 5634 5633.84
14872 02/23/09 4945.45 4945 4945.45
14946 02/26/09 5601.29 5601 5601.29
14981 03/02/09 5861.65 5862 5861.65
29539 02/26/09 4727.41 4727 4727.41

APPRICIATE ANY ADVISE.
THANKS

Configuration: Windows XP
Internet Explorer 7.0

Best answers for « NEED HELP WITH EASY MACRO COPY PASTE/EXCEL » in :
Copy/Paste problems when using Firefox ShowCopy/Paste problems when using Firefox Pushow Adware Extensions It happens that sometimes, Firefox refuse to copy/paste items. Two assumptions can be made: Pushow Adware You have been infected by an adware, named pushow**.dll...
Vi/Vim - Avoid tabs when making a copy/paste Show[VI/VIM] Avoid tabs when making a copy/paste By default, when you make a copy and paste in vi or vim (through an remote SSH session), it adds incremented tabs at each line. To solve this problem,simply type: set paste in the window or add the...
Copy, Paste and Cut not functioning ShowCopy, Paste and Cut not functioning Issue Solution Issue I am having a problem, every time i want to copy, paste and cut my files, it's not working. Even am trying to use the keyboard combinations, CTRL+X, CTRL+C, and CTRL+V but it's...
Download FastPaste Show
Download Quicknote Show
Download Fonter viewer ShowFonter viewer is a tool to view fonts. The program uses HTML to view the installed fonts on your computer. View all the fonts and print the font list or an example of a font text. Use the clipboard of Windows and copy/paste to compare various...
Ask your question Reply

1

WutUp WutUp, on Mar 7, 2009 11:02:55 pm GMT

Hope this helps!


Sub SeparateColumn()

Dim SepInfo As Range

Set SepInfo = Columns(1)

SepInfo.TextToColumns Destination:=Range("B1"), DataType:=xlDelimited, Space:=True

End Sub

   
Reply to WutUp WutUp

2

SCHRAMBOW, on Mar 8, 2009 2:36:41 am GMT

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

   
Reply to SCHRAMBOW

3

 darwinchin, on Oct 2, 2009 4:50:21 am BST

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

   
Reply to darwinchin
Ask your question Reply
They need your help