| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
copying data during iterations
i have a worksheet with formulas that goes through iterations. right now i set the iterations to 3600 to represent a time step of 1 hour. i then have to copy and paste the results and then iterate for another 3600 and again copy and paste. i do this for as many hours as i would like to run the simulation. is there a way i can have excel automatically copy and paste the results while it is iterating. this way i can just set it to go through the maximum number of iterations and it will record the values on its own at 1,2,3,etc hours. the problem seems to be that if i tell it to paste the values after the iterations reach a certain time, that anytime after that time it continues to update the values. i just need it to paste the values at one time and leave it alone. thanks -- aminal ------------------------------------------------------------------------ aminal's Profile: http://www.excelforum.com/member.php...o&userid=36809 View this thread: http://www.excelforum.com/showthread...hreadid=565184 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
copying data during iterations
i have not been using code for this, but am hoping to do it through a logic statement in the cells. -- aminal ------------------------------------------------------------------------ aminal's Profile: http://www.excelforum.com/member.php...o&userid=36809 View this thread: http://www.excelforum.com/showthread...hreadid=565184 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
copying data during iterations
i have not been using code for this, but am hoping to do it through a logic statement in the cells. -- aminal ------------------------------------------------------------------------ aminal's Profile: http://www.excelforum.com/member.php...o&userid=36809 View this thread: http://www.excelforum.com/showthread...hreadid=565184 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
copying data during iterations
Perhaps an explanation is in order
-- Don Guillett SalesAid Software "aminal" wrote in message ... i have not been using code for this, but am hoping to do it through a logic statement in the cells. -- aminal ------------------------------------------------------------------------ aminal's Profile: http://www.excelforum.com/member.php...o&userid=36809 View this thread: http://www.excelforum.com/showthread...hreadid=565184 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
copying data during iterations
perhaps someone else can help -- aminal ------------------------------------------------------------------------ aminal's Profile: http://www.excelforum.com/member.php...o&userid=36809 View this thread: http://www.excelforum.com/showthread...hreadid=565184 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
copying data during iterations
perhaps
-- Don Guillett SalesAid Software "aminal" wrote in message ... perhaps someone else can help -- aminal ------------------------------------------------------------------------ aminal's Profile: http://www.excelforum.com/member.php...o&userid=36809 View this thread: http://www.excelforum.com/showthread...hreadid=565184 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto-increment data source cell references when copying charts | Excel Discussion (Misc queries) | |||
| Copying filtered data to another Excel Spreadsheet | Excel Discussion (Misc queries) | |||
| Inserting a new line when external data changes | Excel Discussion (Misc queries) | |||
| Line Graph Data Recognition | Charts and Charting in Excel | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Linear Mode
