+ Reply to Thread
Results 1 to 1 of 1

Loop through worksheets containing graphs, copy both ChartObjects into another sheet

  1. #1
    Registered User
    Join Date
    10-15-2012
    Location
    London, England
    MS-Off Ver
    Office 365
    Posts
    8

    Loop through worksheets containing graphs, copy both ChartObjects into another sheet

    In my Workbook, I have multiple worksheets that each contain 2 graphs – I want to loop through these sheets copying ChartObjects("Chart 1") and ChartObjects("Chart 2") to appear side-by-side in another sheet named "Graphs".

    To clarify, the worksheets that contain 2 graphs are named "Album", "Single", "CD" and "Cassette". I want to first select the “Album” sheet, copy ChartObjects("Chart 1") into cell A3 of “Graphs” and ChartObjects("Chart 2") into cell K3 of "Graphs", next I want to select the “Single” sheet and copy ChartObjects("Chart 1") into cell A24 of “Graphs” and ChartObjects("Chart 2") into cell K24 of "Graphs", and so on for “CD”, “Cassette” etc, etc.

    I have researched this problem but could not find a solution, as such I am currently using a code that simply selects each sheet in turn and copy/pastes the graphs - I am sure there is a better approach unfortunately it's beyond my limited VBA skills.

    Please let me know if anything needs to be clarified.

    I did ask a similar question on StackOverflow but it was closed by the moderators for being "unfocussed" (I haven't been able to post the link as it's my first post here) - I sent them a re-worded post but it is still closed.

    Regards, TE
    Last edited by TheEnd; 03-04-2020 at 07:44 AM. Reason: Cross-posting reason

+ 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] Loop Sheets with VB to copy information from all worksheets to on overview sheet
    By MoldyBread in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 07-26-2018, 04:40 AM
  2. Loop through worksheets and copy data ranges into one sheet
    By mcaballero in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-03-2015, 04:44 PM
  3. Replies: 1
    Last Post: 05-20-2014, 10:44 AM
  4. VBA Macro to loop through a Yes/No Chart to copy graphs onto new page
    By cgermanjr in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-24-2013, 03:33 PM
  5. Looping through Worksheets, Copy/Paste Each Sheet during Loop
    By eduardito in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-02-2012, 07:01 AM
  6. How to copy ChartObjects from one Worksheet to another?
    By ffffloyd in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 11-10-2011, 01:30 AM
  7. [SOLVED] Loop through combo and copy graphs to Powerpoint
    By Martin Los in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-04-2005, 08:05 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