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

--
legep
-----------------------------------------------------------------------
legepe's Profile: http://www.excelforum.com/member.php...fo&userid=1548
View this thread: http://www.excelforum.com/showthread.php?threadid=27101

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

"legepe" wrote in message
...

Hi all,
I am really desperate to finish a program that i am building using
excel 2000.
I want to copy data using macros into another sheet to get an
accumulation of data.
below is as far as i have got with trying to do this. i need help in
making the macro put the data into a column next to the one previously
used.
I hope that this is understandable, and I hope that someone can help me
with this. I have already looked at
-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 is
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 Sub


--
legepe
------------------------------------------------------------------------
legepe's Profile:
http://www.excelforum.com/member.php...o&userid=15485
View this thread: http://www.excelforum.com/showthread...hreadid=271018

I think Greg has a couple of typos:

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



Greg Koppel wrote:

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

"legepe" wrote in message
...

Hi all,
I am really desperate to finish a program that i am building using
excel 2000.
I want to copy data using macros into another sheet to get an
accumulation of data.
below is as far as i have got with trying to do this. i need help in
making the macro put the data into a column next to the one previously
used.
I hope that this is understandable, and I hope that someone can help me
with this. I have already looked at
-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 is
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 Sub


--
legepe
------------------------------------------------------------------------
legepe's Profile:
http://www.excelforum.com/member.php...o&userid=15485
View this thread: http://www.excelforum.com/showthread...hreadid=271018


--

Dave Peterson