Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
YTD % over 12 accumulating figures | Excel Worksheet Functions | |||
Accumulating a total | Excel Worksheet Functions | |||
Accumulating numbers | Excel Worksheet Functions | |||
Accumulating cells | Excel Discussion (Misc queries) | |||
accumulating total | Excel Discussion (Misc queries) |