LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
YTD % over 12 accumulating figures Ellie Excel Worksheet Functions 1 May 27th 10 11:03 PM
Accumulating a total JD Excel Worksheet Functions 4 January 19th 09 11:00 PM
Accumulating numbers Jem Excel Worksheet Functions 1 July 30th 07 09:14 AM
Accumulating cells RR Dunn Excel Discussion (Misc queries) 3 April 18th 07 01:40 PM
accumulating total exhausted everything Excel Discussion (Misc queries) 1 March 15th 06 12:24 AM


All times are GMT +1. The time now is 04:19 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"