Search : in
By :

Macro: copy and paste

Last answer on Oct 28, 2009 7:07:39 am GMT Dee, on Oct 27, 2009 4:02:03 pm GMT 
 Report this message to moderators

Hello,
Can anyone help me, please?
I want an excel macro that will copy and paste some data. I have a column of data from A1 to A31. I would like a macro that can copy data from cell A1 and paste in the cell range A40 to A60, then copy A2 and put it in cell range A61 to A80 than copy A3 and paste into A81 to A100, etc.

Regards,
Dee.

Configuration: Windows Vista
Firefox 3.0.14

Best answers for « Macro: copy and paste » 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...
Quick Copy/Paste under Ubuntu ShowQuick Copy/Paste under Ubuntu Intro Uses: Intro Under Ubuntu there is a quicker alternative to make a Copy/Paste other than using the native CTRL V and CTRL C combinations . You simply select the target text (it is uploaded in...
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...
Download FastPaste 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...
Download Super Audio Editor Show
Linux - The Vi editor ShowIntroduction to Vi Despite its very limited ergonomics, Vi i is one of the most popular text editors texte under Unix type systems (with Emacs and pico). Under Linux, there is a free version of Vi called Vim (Vi Improved). Vi (pronounced vee-eye)...
Ask your question Reply

1

venkat1926, on Oct 28, 2009 2:36:44 am GMT

A40 to A60 are 21 rows where as A61 to A80 are 20 rows and also A81 to A100 are 20 rows. To void inconsistency I have made the first set A41 to A60

in that case use this macro 

Sub test()
Dim j As Integer, k As Integer
For j = 1 To 31
k = (j + 1) * 20
'MsgBox k
Cells(j, "A").Copy
Range(Cells(k + 1, "A"), Cells(k + 20, "A")).PasteSpecial
Next j
End Sub

   
Reply to venkat1926

3

 Dee, on Oct 28, 2009 7:07:39 am GMT

Great Thanks, It worked perfectly.

Regards,
Dee

   
Reply to Dee
Ask your question Reply
They need your help