PDA

View Full Version : Copying Cells form one worksheet to another


Luc
Feb 16, 2007, 03:27 AM
Hi,

I have a worksheet that at the end of everyday a button is pushed and the data form a range of cells is copied into another worksheet..

The only thing is I can only get it to copy into cerntain cells on the other worksheet, meaning that the previous nights data is over-written.

How can I make a macro so that when the button is pressed again the data is copied to line below the previous nights data?

Kind regards

Luc

ScottGem
Feb 16, 2007, 06:12 AM
The Code would look like this:

Range("A21").Select
Selection.End(xlDown).Select
SendKeys("{Down}")

A21 is the top of the range you want to copy to. The next 2 commands will move to the first emply cell in that range.