+ Reply to Thread
Results 1 to 2 of 2

Make a dynamic 'sheet' active to be able to extract data into an array.

  1. #1
    Forum Contributor
    Join Date
    02-13-2017
    Location
    Durham
    MS-Off Ver
    2013
    Posts
    126

    Make a dynamic 'sheet' active to be able to extract data into an array.

    Hi All,

    Firstly thanks for help in advance, people in this forum are fantastic

    My issue is as follows:

    I'm trying to copy data into an array from various workbooks and then put said data into another set workbook. My source workbook has 3 SET worksheets which do not vary meaning getting data from these is perfectly fine and I've accomplished this task.
    However, AFTER these sheets there are other sheets with info I need on however they're always named differently in each workbook. This can range to 1 extra sheet or 10 extra sheets.

    An example would be that my Source workbooks may have sheets called:

    A, B, C Then 54, 59
    A, B, C Then 99, 101
    A, B, C then 12, 84, 59, 78
    etc

    I can take any info from sheets A,B,C on any workbook however Its navigating to the data on the dynamic worksheets I have issues with.

    The only solution I can think of is that on those dynamic worksheets, there is ALWAYS the same Headers so perhaps I can do something along the lines of:

    Please Login or Register  to view this content.
    Any ideas?

    Thanks In advance, this ones a toughy!!

  2. #2
    Forum Contributor
    Join Date
    02-13-2017
    Location
    Durham
    MS-Off Ver
    2013
    Posts
    126

    Re: Make a dynamic 'sheet' active to be able to extract data into an array.

    Hi Admin, Apologies I tried to edit my original post and accidently created a new thread,

    Please delete as it's a duplicate

    Again, apologies

+ 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] Make a dynamic 'sheet' active to be able to extract data into an array.
    By Scoobster_doo in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-06-2017, 01:13 PM
  2. Change Array formulas to make them Dynamic
    By julhs in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-09-2017, 09:01 AM
  3. make a sort by active sheet, not specific sheet
    By tsiguy96 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-31-2014, 11:25 AM
  4. make an array reference cells on another worksheet of the active workbook.
    By mbr@gmx.us in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-27-2014, 02:31 PM
  5. Make a Sheet Active from Code
    By rau in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-02-2014, 01:25 AM
  6. Possible to make an Excel sheet that can extract data from Google?
    By simpleonline1234 in forum Excel General
    Replies: 1
    Last Post: 05-18-2010, 01:57 PM
  7. Code to make a sheet active
    By hshayh0rn in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 02-05-2006, 06:30 PM

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