Results 1 to 5 of 5

Extracting Data from Excel to copy and Paste

Threaded View

  1. #1
    Registered User
    Join Date
    12-13-2009
    Location
    new york, usa
    MS-Off Ver
    Excel 2003
    Posts
    17

    Question Extracting Data from Excel to copy and Paste

    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.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1