Copying block of data to another sheet

[SParikh]

Hello everybody

I am looking out for a code where I can copy a block of data to
the second sheet and adding the new block of data below the
previous one.

The block of data ranges from E6 to K15. On a click of the
command button the data gets copied to sheet2 starting from
A2. It will be pasted in sheet2 from A2 to G11.
When I click the command button with the new data it will be
added from A12 to G21 after that A22 to G31 and so on It will
keep on adding the block.

Can I get the problem solved

Thanks in advance
SParikh

[HaHoBe]

Hi, SParikh,

maybe like this:

Please Login or Register  to view this content.

How to install your new code

1. Copy the Excel VBA code
2. Select the workbook in which you want to store the Excel VBA code
3. Press Alt+F11 to open the Visual Basic Editor
4. Choose Insert > Module
5. Edit > Paste the macro into the module that appeared
6. Close the VBEditor
7. Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)

To run the Excel VBA code:

1. Press Alt-F8 to open the macro list
2. Select a macro in the list
3. Click the Run button

Ciao,
Holger

[Swalih]

Hi SParikh,

Try this. Assuming that Sheet1 is where u have the data & Sheet2 is where u want the data. for this code to suit u properly u have to select Range E6 and then run the code. ( If ur block of data ranges from A8 to A17 then u should select Range A8 )

Please Login or Register  to view this content.

[HaHoBe]

Hi, Swalih,

besides working on the code to avoid Selection you should have mentioned that Range A2 needs to be activated in sheet2 as the pasting will always be done at the ActiveCell.

Please Login or Register  to view this content.

Ciao,
Holger

[SParikh]

Hi! HaHoBe
Sorry for the delay in replying back.
I have tried your first code which is working exactly as I wanted.


I am yet to try the other code given by Swalih. However since issue is solved by the code
by HaHoBe do we still continue with the other available options.
I will try again both the other codes and reply back in a day or two. But for the time being the
the first code has solved my problem.

Thanks a lot for reply
HaHoBe & Swalih.