Hi everyone, I am currently working on a excel spreadsheet for investing purposes. One sheets gives the user the option the fill in an exchange and the stock Ticker. When the user clicks on the "Get data" button all the fiscal financial data (income statement etc.) is put into the appropriate sheet. It looks like this:
screen2.png
I would like to be able to make graphs with this data automatically without having to select the cel range myself. the problem is that the financial statements vary. So while the net income may be on 16B for Apple it could be on 18B for Microsoft, the name for that value 'net income' of course stays the same. Is there a way to make VBA look for the cell for ' net income ' and then take the data to the right from it?
With kind regards, Toni
Bookmarks