|You probably need to find the last cell in the column and then offset 1 down to populate the the row with the new date and price. We can do this in VBA like:|
There is an open source program to download market data for multiple stocks that we developed here. This has a lot of code that might also help with your project.
| ||Excel Business Forums Administrator|
| ||Posted by Excel Helper on |