View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
legepe[_4_] legepe[_4_] is offline
external usenet poster
 
Posts: 1
Default Accumulating data


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