+ Reply to Thread
Results 1 to 5 of 5

Import graph from a specific workbook if a cell matches the workbook name

  1. #1
    Registered User
    Join Date
    07-27-2013
    Location
    London, England
    MS-Off Ver
    Excel 2007,2010, 2013
    Posts
    26

    Import graph from a specific workbook if a cell matches the workbook name

    Dear Geniuses,

    Is there a way to import a graph from a certain workbook and specific sheet into a main summary sheet if a cell matches the workbook name.

    That's to say, the sub or macro will be assigned to a specific cell (say A10) so that a graph is copied from another book which is named same as the text in another cell (say A1) and pasted as image or chart....
    ---------
    We have Book 1 and Book 2
    in book 1 cell A10 a graph will be imported from book2 sheet 1 if A1=book2 ( I do not know id chart cab also be referred to as range of cells)

    Thank you in advance,
    M.

  2. #2
    Valued Forum Contributor Parth007's Avatar
    Join Date
    12-01-2014
    Location
    Banglore
    MS-Off Ver
    2010
    Posts
    879

    Re: Import graph from a specific workbook if a cell matches the workbook name

    Hi Hassan,

    Please see the below link.. you may get an idea or little bit modifications of the code will work in your case to transfer data from excel to excel..


    http://www.ozgrid.com/forum/showthread.php?t=24486

    or

    http://www.cimaware.com/resources/article_107.html

    Somewhere near... give a try & do RnD :D
    Regards
    Parth

    I appreciate your feedback. Hit * if u Like.
    Rules - http://www.excelforum.com/forum-rule...rum-rules.html

  3. #3
    Registered User
    Join Date
    07-27-2013
    Location
    London, England
    MS-Off Ver
    Excel 2007,2010, 2013
    Posts
    26

    Re: Import graph from a specific workbook if a cell matches the workbook name

    many thanks Parth, I will give it a go and see how it goes.
    BTW how can I make the paste as image?

    Best wishes

  4. #4
    Registered User
    Join Date
    07-27-2013
    Location
    London, England
    MS-Off Ver
    Excel 2007,2010, 2013
    Posts
    26

    Re: Import graph from a specific workbook if a cell matches the workbook name

    Dear All,

    I have attached a workbook with clarification inside for the ease of interpretation.

    Many Thanks in advance.sample for excel forum.xlsm

  5. #5
    Valued Forum Contributor Parth007's Avatar
    Join Date
    12-01-2014
    Location
    Banglore
    MS-Off Ver
    2010
    Posts
    879

    Re: Import graph from a specific workbook if a cell matches the workbook name

    Hassan, got not idea abt it.. Experts will surely help you in this..

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Copy filename of source workbook to specific cell in specific tab in destination workbook.
    By MagicMan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-28-2015, 10:29 PM
  2. [SOLVED] Import Specific Sheet into Workbook with VBA
    By chicagoland8 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-18-2014, 04:10 PM
  3. Import specific data from one workbook another!
    By iluvfnky in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-18-2014, 09:54 AM
  4. How to import excel specific data to a new workbook
    By GEMINI528 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-13-2013, 02:35 PM
  5. [SOLVED] Import from 2nd workbook to specific worksheet
    By ERoemer in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-31-2013, 03:15 PM
  6. Replies: 2
    Last Post: 11-17-2010, 11:39 AM

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