Extracting Data from Excel to copy and Paste

[davey11372]

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.

[Richard Buttrey]

Hi,

See attached

Put your required times in L1 & L2 in the format 12:40:10

Please note that your times in column B are not time numbers, hence it's necessary to add the helper column D which converts column B to time numbers that Excel can use.

Please also note that the Dates are not proper date numbers either - they have a leading space. I know you don't need to use these dates for any analysis in this example but for future reference you should always try to get dates and times into a proper Excel number format so that Excel has something to work with.

Note: the forum seems to have a problem uploading files at the moment. I'll attach as soon as it's available.

HTH

[davey11372]

Thank you Richard.

I will wait to see your attachment. I was able to upload mine, a few minutes before your reply.

[davey11372]

Richard, perhaps this is what you may have been referring to, I just realized the data in the worksheet has been saved in text format. Sorry did not realize/mention that earlier.

[Richard Buttrey]

Hi,

See attached

It seems the size of the file was too large although why you're original uploaded and this one didn't I can't fathom. I've had to remove rows below 2500 but no doubt you can copy them back in/

Regards