Macro to cut & paste continually adding data?

Hello,

Is it possible to write a simple macro that will cut data & paste it? For example, when I run this macro it

cuts the data from cells A1:A3 and pastes it in cells D1:D3?

Hi Rick-O-Shay,

welcome to the forum.

Have you tried using the macro recorder to do the copy and paste? That's a good starting point to create macros that you can edit and change to your needs, if you want to learn about VBA.

You can try out the differences with relative and absolute referencing and try and define source cells and target cells for the copy and paste operation after studying the code.

Once you have a base example, you could come back here for advice on fine-tuning.

hth

OK,

start the macro recorder, do your copy and paste thing and stop the macro recorder.

Then post the generated code here and ask how this code can be modified to paste in the next available empty row.

I'm sure you will get answers (not from me, though, I'm afraid I'm still learning this stuff myself!)

cheers

Here's what Teylyn means,

Try to understand the recorded macro. Then rework it to a more efficient code. VBA recorder in XL is not that good. It was much better in Lotus 123 (so I heard)

Please Login or Register  to view this content.

and reworked:

Please Login or Register  to view this content.

Ok here is my base code

Please Login or Register  to view this content.

Ok, Here is my problem. I need to make this code so that each time it is run the data is dropped down a line. For example, it is run this time and pasted in A8:C8, next time it pastes the data in cells A9:C9... how do I do this?

So if I understand correctly:
A1:C1 has the data.
This data needs to be put under the last recorded log?

What can be done is find out where the last enty is. This is done frequently with the code.

Please Login or Register  to view this content.

Putting this together with your current code:

Please Login or Register  to view this content.