Results 1 to 1 of 1
2015-04-02, 14:49 #1
- Join Date
- Apr 2015
- Thanked 0 Times in 0 Posts
How to copy a data from another Workbook and create a graph in different workbook?
I need a help to draw a conditional graph in excel using vba.
I am using the two excel workbook for that. 1 is the tool in which I want to display a graph and the another one is Net ernings Log from which I want to take the data and create the graph in Tool workbook.
Excel Work book 1: Statement Tool,
Sheet Name: Merchant: Creating a tool. On cell A27 the graph should display
Excel Work book 2: Net Earnings Log
SheetName: Net Earnings : Displayed with TID No and Monthly earnings as in the sheet.
Now I want to compare the TID No in workbook 2 with TextBox1 when it matches, the data displayed with months in Net Earnings should be selected for last 12 months and create the graph and display on the Workbook1 Statement Tool sheet named with Merchant.
Kindly help on this.
Thanks a lot in advance.