Results 1 to 1 of 1
  1. #1
    New Lounger
    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?

    Hello everyone!

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

Posting Permissions

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