+ Reply to Thread
Results 1 to 1 of 1

Macro to copy charts from multiple workbooks and paste images in single workbook in order

  1. #1
    Registered User
    Join Date
    06-11-2013
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    7

    Macro to copy charts from multiple workbooks and paste images in single workbook in order

    attachments.zipHi,

    I have multiple workbooks, where data and Charts are placed in different tabs. Charts tab is common for all workbooks.

    Requirement is to have new master workbook containing macro, which will fetch charts(input different cell ranges for each workbook) from *df* and *iostat* workbooks and paste them as images in master workbook, one below another.

    Macro has should be flexible to add multiple workbooks.

    If there is an input master workbook, containing input tab with following user inputs:

    1) workbooks filename (based on this filename order, master file will have pasted chart images ordered)
    2) file path
    3) tab from where charts has to be fetched(in this case its always Charts tab)
    4) Data Range Start Cell (this is ideally the range depending on number of charts in Charts tab)
    5) Data Range End Cell (this is ideally the range depending on number of charts in Charts tab)
    6) Copy To Sheet (Sheet in Master workbook)
    7) CopyToLocation(Start Cell Only of sheet in Master workbook)

    attached sample workbooks for reference.

    thanks in advance,
    Last edited by sksajid7; 06-08-2015 at 04:04 AM.

+ 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. Macro to copy formulas from multiple workbooks into new workbook (paste text of formula)
    By robertsfd2002 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-24-2014, 12:46 PM
  2. [SOLVED] Open Multiple Workbooks, Record names, Copy paste to Active Workbook, Close the Workbooks
    By vba_madness in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-24-2013, 06:09 AM
  3. How to Copy Data from multiple workbooks to single workbook
    By Gautam Garg in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 07-23-2012, 04:17 PM
  4. [SOLVED] Copy from single workbook and past to multiple workbooks
    By Alby22 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-17-2012, 04:40 PM
  5. macro to copy data from multiple workbooks in a single workbook
    By blyzzard in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-03-2011, 05:34 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