+ Reply to Thread
Results 1 to 5 of 5

How to collect the data from various sheets into one

  1. #1
    Registered User
    Join Date
    03-13-2014
    Location
    Athens, Greece
    MS-Off Ver
    Excel 2007
    Posts
    59

    How to collect the data from various sheets into one

    Hello all,

    In a previous thread (http://www.excelforum.com/excel-form...ml#post3645634) I needed the data I put in one sheet to be distributed in the rest of the (similar) sheets based on the name in column A (the name in column A is the name of the destination sheet) and an expert here solved it with macro code (see the attached xlsm).

    Now I need the other way around. Agents will put the data in the sheets (in the attached workbook: agent1, agent2 etc) and their input to be summarized in master file sheet. In the attached file the macro code works for columns A-K. In the new one I need the range to be A-W. I tried to replace the K with W in the code but it didn t work...

    Can anyone tranform the code in the file so as to work as I explained above?

    If you need more clarifications please tell me.

    Any help will be highly appreciated!
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    11-28-2012
    Location
    Guatemala
    MS-Off Ver
    Excel 2010
    Posts
    2,394

    Re: How to collect the data from various sheets into one

    try this code...

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    03-13-2014
    Location
    Athens, Greece
    MS-Off Ver
    Excel 2007
    Posts
    59

    Re: How to collect the data from various sheets into one

    Hi rcm!

    Thanks a lot for your answer.

    I selected "view code" and I pasted you code. I did some changes in the sheets but nothing happened. The macros are enabled.
    Did I do something wrong?

  4. #4
    Forum Expert
    Join Date
    11-28-2012
    Location
    Guatemala
    MS-Off Ver
    Excel 2010
    Posts
    2,394

    Re: How to collect the data from various sheets into one

    Try this version
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    03-13-2014
    Location
    Athens, Greece
    MS-Off Ver
    Excel 2007
    Posts
    59

    Re: How to collect the data from various sheets into one

    OMG!! It works!!!
    Thank you so much!!

    Ang you did this for all the columns in use!

    Great work! Thanks!!

+ 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. Collect data from more sheets
    By ikke88 in forum Excel General
    Replies: 2
    Last Post: 11-30-2015, 08:03 AM
  2. Collect data from multiple sheets
    By xe-dingo in forum Excel General
    Replies: 2
    Last Post: 09-22-2014, 02:38 PM
  3. Collect Data from all 8 sheets into 1 sheet using Tables
    By farazexcel in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-09-2014, 05:56 AM
  4. Replies: 2
    Last Post: 12-17-2013, 08:21 AM
  5. xls, collect data from different sheets into one sheet.
    By Aqwa in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-21-2011, 02:49 PM
  6. Collect matching data from all sheets.
    By dingobat in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-08-2010, 11:21 AM
  7. how to collect data from other work sheets
    By drgogo in forum Excel General
    Replies: 3
    Last Post: 02-12-2008, 09:55 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