Home > Forum Home > Automating Data Analysis Tasks > Using excel to automatically build a database of stock data > Go to end row | Share |
Forum Topic | Login |
Go To End Row | Rate this: (3/5 from 1 vote) |
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: VBA Code:
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 |
View Full Post |
Excel templates and solutions matched for Go to end row:Solutions: Budget Planning |