Results 1 to 6 of 6

Capture data between 2 dates

Threaded View

tatfish87 Capture data between 2 dates 07-29-2014, 11:02 PM
cemregunay Re: Capture data between 2... 07-29-2014, 11:36 PM
FDibbins Re: Capture data between 2... 07-29-2014, 11:45 PM
cemregunay Re: Capture data between 2... 07-29-2014, 11:52 PM
FDibbins Re: Capture data between 2... 07-29-2014, 11:53 PM
tatfish87 Re: Capture data between 2... 07-30-2014, 01:53 AM
  1. #1
    Registered User
    Join Date
    07-29-2014
    Location
    Hong Kong
    MS-Off Ver
    2010
    Posts
    34

    Red face Capture data between 2 dates

    Dear professionals

    I am newbie for excel programming. I have attached an excel file for easy reference.
    The Date is at column A, and the stock price is at column B. (both data is on Sheet1)

    On Sheet2, there is 2 cells "FROM" and "TO".

    I wish to create a button on sheet2 that, after i fill in the (dd/mm/yyyy) into the "FROM" and "TO", and press that button, the excel will extract the corresponding data from sheet1 and paste on sheet2, with a simple graph plotted automatically with the extracted data.

    Thank you very much in advance for teaching me such skill.

    Thanks and regards
    tatfish
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 0
    Last Post: 05-22-2014, 12:47 PM
  2. [SOLVED] Help with Formula to capture dates to be populated on a calendar
    By Inez15 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-08-2013, 06:27 AM
  3. Replies: 3
    Last Post: 09-02-2011, 04:03 PM
  4. Using VBA to capture data
    By missmangan@gmail.com in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-02-2010, 03:53 AM
  5. Data Capture
    By allagash in forum Excel General
    Replies: 2
    Last Post: 07-15-2010, 10:20 PM

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