adding data to a list from another worksheet that updates automa

's Computer Specifications

Hello,
I have a list that the stock closeing prices update automatically once I
open the file. I want to have the closing price from the worksheet I have
move to another worksheet that will track the closing prices on a day to day
basis putting it into a list by day. I know I need some sort of Macro loop,
but i'm not sure how to make it work.
Thansk
Tiffany

's Computer Specifications

Hi.
Is it possible that new stocks be added in the daily list ?
Regards.
Daniel

> Hello,
> I have a list that the stock closeing prices update automatically once I
> open the file. I want to have the closing price from the worksheet I have
> move to another worksheet that will track the closing prices on a day to day
> basis putting it into a list by day. I know I need some sort of Macro loop,
> but i'm not sure how to make it work.
> Thansk
> Tiffany

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Automatically extend a list when adding a new data to another list	JB	Microsoft Excel Misc	0	25th Mar 2010 02:50 PM
how do I keep cell (after I put data in it) from going down automa	=?Utf-8?B?Ym9qb2Nv?=	Microsoft Excel Misc	1	13th Feb 2007 02:27 AM
list worksheet macros/VBA without adding worksheet	=?Utf-8?B?YnI1NDk=?=	Microsoft Excel Misc	0	6th Jan 2006 10:17 PM
How do I stip outlook from adding addresses to my contacts automa.	=?Utf-8?B?UmVnbmFy?=	Microsoft Outlook Contacts	3	10th Mar 2005 04:31 PM
Updates to data based on a query (adding spaces before the data)	=?Utf-8?B?Y29uZnVzZWRQTQ==?=	Microsoft Access Reports	5	21st Oct 2004 08:21 PM