I have data in Excel in 3 columns.
Column A has Date
Column B has Time
Column C has Stock Price
I am trying to copy the stock price for a certain time interval each day for different dates and paste them to column F.
eg. I would like to copy stock prices between 10:30 am to 11:00 am for the dates 8/10/09 to 8/15/09 and paste the data to column F.
How can I create a macro to do this?
I have attached a sample data sheet herewith.
Thank you.
Bookmarks