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
Bookmarks