Results 1 to 2 of 2

Thread: Combine Tabs on different work books to One Tab in another workbook
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Feb 2019
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Combine Tabs on different work books to One Tab in another workbook

    I really need help with this. So here is my problem.
    I have 50 Case Mangers in different parts of the state
    --- they have 50 Participants
    Each participant has a separate file.
    That means approximately 250 separate files are sent to me monthly.

    Each file has approximately 10 tabs
    Tab 1 Tab 2 Tab 3 etc.
    I have named one of the tabs MIS it has 176 Data Elements that need to be answered.
    That means I am collecting approximately 900 Data Elements.
    By Data Elements I mean 900 cells of information collected in separate cells.
    The Data Elements are in (Column A Row 1) and end in (Column FV Row 1).
    I need to collect all this Data in to one spreadsheet and submit it once a month.
    Each Participant file has a tab labeled MIS
    So, I need to grab that tab from all Participant files and combine them into one spreadsheet.
    Is there a way to do this? I have searched and found

  2. #2
    Board Regular sergioMabres's Avatar
    Join Date
    Feb 2013
    Location
    Córdoba, Argentina
    Posts
    946
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Combine Tabs on different work books to One Tab in another workbook

    Hi Gerri,
    Yes there is, but you will have problems due to the volume of information and the amount of ppl involved, I had a similar problem, I've tried to make it work for more than two year in a project and finally decided to replace all sheets for a workflow web based system where every one inputs info, the workflow send the information to each one at the right time, and finally consolidates results at the end of the month to be once more evaluated, this is my experience in a subject that involves lots of info, reviews and ppl.
    Cheers
    Sergio
    Last edited by sergioMabres; Feb 20th, 2019 at 08:21 AM.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •