I have a sheet1 with all the symbols of the NASDAQ stock exhange.( From A1 to A7000)
In sheet2 are the same stock symbols downloaded with the closing prices of the day.
Who can give me a macro that convert each day the closing stock prices from Sheet2 to sheet1 with the same symbol in column B.
The stock proces in sheet2 are in column 7
Many thanks.
In sheet2 are the same stock symbols downloaded with the closing prices of the day.
Who can give me a macro that convert each day the closing stock prices from Sheet2 to sheet1 with the same symbol in column B.
The stock proces in sheet2 are in column 7
Many thanks.