+ Reply to Thread
Results 1 to 3 of 3

Combining Text

  1. #1
    Registered User
    Join Date
    01-25-2010
    Location
    Portland or
    MS-Off Ver
    Excel 2003
    Posts
    27

    Combining Text

    Hi, I have 10 tabs that are identical. Each tab has written text in columns a, b, c, d, e. Each tab has a different number of rows of information and the numbers of rows in each changes each time I update a tab.

    I would like to create a summary tab that will show all the information written in tab 1, and then go to tab 2 and so on. I need the summary tab to catch all the information when the tabs are updated.

    Any suggestions? I realize you can not use the consolidation tab for text.

    Thanks!

  2. #2
    Registered User
    Join Date
    06-08-2010
    Location
    San Francisco
    MS-Off Ver
    Excel 2003
    Posts
    1

    Re: Combining Text

    you can try using indirect to pull information from different tabs. If the number of rows is going to change, you probably want some kind of lookup that will get you the number of rows and which rows.

    ------------------
    Jon
    http://www.excelinexcel.com

  3. #3
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,202

    Re: Combining Text

    Best approach is not to use multiple tabs,but have one tab that holds all the data but has a column that acts as an identifier. Then depending on the data you can use various methods toanalyseit
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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