+ Reply to Thread
Results 1 to 5 of 5

multiple sheets data to one?

  1. #1
    Registered User
    Join Date
    08-22-2014
    Location
    Finland
    MS-Off Ver
    2013
    Posts
    2

    multiple sheets data to one?

    Hello

    Look at attached file

    I would need to be able to retrieve to one sheet all the data from multiple sheets so that one has new column that tells which sheet the data was retrieved from.
    Can this be done?
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: multiple sheets data to one?

    Sheet 1 and sheet 2 are input sheets?

    What are the values in sheet 3 (%)?

    Please add the desired (expected) result in your excel file.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Forum Expert
    Join Date
    03-28-2014
    Location
    Hyderabad,India
    MS-Off Ver
    Excel 2013
    Posts
    1,887

    Re: multiple sheets data to one?

    I think this will help you .

    Punnam
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    08-22-2014
    Location
    Finland
    MS-Off Ver
    2013
    Posts
    2

    Re: multiple sheets data to one?

    Punnam

    Excellent. almost what I was looking for.
    This will save my time once I get it working. There are many tens of sheets I need to make one table. and then this is only from one month.

    was this a macro or a script?

    /mika

  5. #5
    Forum Expert
    Join Date
    03-28-2014
    Location
    Hyderabad,India
    MS-Off Ver
    Excel 2013
    Posts
    1,887

    Re: multiple sheets data to one?

    No it is just a indirect function .
    But the same requires some manual work.

    Clarification Required
    1) Kaikki (n=5334)Miehet (n=2627)Naiset (n=2707)9-14 v (n=412)15-34 (n=1388)35-54 (n=1482)55+ (n=2052) the present count is 7 will they grow in number per sheet
    2) =INDIRECT("'"&$A$14&"'"&"!"&ADDRESS(ROW(B5)+2,COLUMN())) every time when u start new sheet make sure the very first is refereeing to B5 row
    3) Need to change $A$14 with respect to new sheet.

    Punnam

+ 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 filter multiple columns of data to multiple work sheets
    By LISSANN in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-10-2014, 07:24 PM
  2. Replies: 0
    Last Post: 07-29-2013, 03:00 AM
  3. Compare multiple data points in row _ multiple sheets _ output different information
    By floydian in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-18-2013, 08:52 AM
  4. Replies: 0
    Last Post: 07-27-2011, 01:00 AM
  5. Replies: 4
    Last Post: 08-17-2006, 01:30 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