Accumulating data

[legepe]

Hi all,
I am really desperate to finish a program that i am building usin
excel 2000.
I want to copy data using macros into another sheet to get a
accumulation of data.
below is as far as i have got with trying to do this. i need help i
making the macro put the data into a column next to the one previousl
used.
I hope that this is understandable, and I hope that someone can help m
with this. I have already looked a
-http://www.rondebruin.nl/copy1.htm#Column
but it has been to no avail, as i am brand new to all of this and it i
to complicated for me to understand.
Thanks
legepe

Sub Macro15()
'
' Macro15 Macro
' Macro recorded 20/10/2004 by Leigh Pender
'

'
Range("J8:J107").Select
Selection.Copy
Sheets("YTD-Results").Select
Range("C12").Select
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:
_
False, Transpose:=False
Sheets("Actual").Select
Application.CutCopyMode = False
End Su

 

[Greg Koppel]

Where you have Range("C12").Select use some form of the following in place

Range("C12").End(xlRight).Offset(1, 0).Select

Change the C12 designation appropriately.

HTH, Greg

 

[Dave Peterson]

I think Greg has a couple of typos:

Range("C12").End(xltoRight).Offset(0, 1).Select