+ Reply to Thread
Results 1 to 2 of 2

Overview sheet that automatically inserts data from other sheets

Hybrid View

  1. #1
    Registered User
    Join Date
    01-07-2016
    Location
    Copenhagen, Denmark
    MS-Off Ver
    2007, 2013
    Posts
    1

    Overview sheet that automatically inserts data from other sheets

    Hi.

    I'm trying to create a sheet that automatically inserts data from other sheets that are continuously added to the workbook. This means that I do not know the number of sheets or the names of the sheets that are to be displayed on the overview sheet.
    The data ranges could be something like A3:F6 for sheet1 to sheetn, and I would like them to be inserted below the previous sheet.

    I'm want it to look something like this:

    Sheet 1
    sheet1!A1 .. .. .. .. sheet1!F1
    .. .. .. .. .. ..
    .. .. .. .. .. ..
    .. .. .. .. .. ..
    .. .. .. .. .. ..
    sheet1!A6 .. .. .. .. sheet1!F6


    Sheet 2
    sheet2!A1 .. .. .. .. sheet2!F1
    .. .. .. .. .. ..
    .. .. .. .. .. ..
    .. .. .. .. .. ..
    .. .. .. .. .. ..
    sheet2!A6 .. .. .. .. sheet2!F6

    ..

    Sheet n
    sheetn!A1 .. .. .. .. sheetn!F1
    .. .. .. .. .. ..
    .. .. .. .. .. ..
    .. .. .. .. .. ..
    .. .. .. .. .. ..
    sheetn!A6 .. .. .. .. sheet2!F6


    I'm guessing that I'm going to need some VBA coding for this, but I can't really figure out how since I am very new to that stuff.
    Is it possible in any way to do this? And how exactly?

    Thanks in advance

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,957

    Re: Overview sheet that automatically inserts data from other sheets

    Please attach a sample workbook, so we can get a better picture of the requirement and have something to test solutions on.

+ 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. Overview sheet with data from different sheets
    By franz89 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-19-2015, 07:22 AM
  2. [SOLVED] Macro to copy data from multiple sheets to overview and align results on overview sheet
    By McBree in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-04-2015, 04:01 PM
  3. VBA Help - Insert a row in Sheet 1 and it automatically inserts in Sheet 2
    By dholiman in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-16-2015, 01:39 PM
  4. Resoruce overview - Create new sheet and add to sumif function in exsisting overview
    By Martinbif in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-27-2013, 09:58 AM
  5. [SOLVED] function to add from a overview sheet information to other sheets
    By benjamin.grimm in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-11-2013, 06:42 AM
  6. Replies: 1
    Last Post: 01-29-2013, 09:19 PM
  7. [SOLVED] Excel automatically inserts a formula in my sheet
    By smurrock in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-06-2006, 10:10 AM

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