Dear Friends,
I'm pulling data from web (NSE India) to excel sheet and refreshing the connection at 5 minutes. Now, every 5 minutes, the data is refreshed. But, I'd like to see the trend of Nifty. So, after the connection is refreshed, I need to copy the data to another sheet along with the time stamp. Something, like below, with column A having the time stamps and column B having the data
A1 B1
10.45 AM 8500
10.50 AM 8555
10.55 AM 8556
11.00 AM 8570
Any help would be highly appreciated. Thanks guys.
I'm pulling data from web (NSE India) to excel sheet and refreshing the connection at 5 minutes. Now, every 5 minutes, the data is refreshed. But, I'd like to see the trend of Nifty. So, after the connection is refreshed, I need to copy the data to another sheet along with the time stamp. Something, like below, with column A having the time stamps and column B having the data
A1 B1
10.45 AM 8500
10.50 AM 8555
10.55 AM 8556
11.00 AM 8570
Any help would be highly appreciated. Thanks guys.
Help needed in Excel
Aucun commentaire:
Enregistrer un commentaire