Results 1 to 3 of 3

Summarizing/Copying dynamic ranges of data to new sheet?

Threaded View

  1. #1
    Registered User
    Join Date
    03-03-2009
    Location
    Pennsylvania, USA
    MS-Off Ver
    Excel 2007
    Posts
    53

    Summarizing/Copying dynamic ranges of data to new sheet?

    OK, I'm not sure how to ask this question...

    How do I summarize dynamic ranges of data to a new sheet?

    For example on sheet1 I might have...

         A     B     C
    1    x     x     x
    2    x     x     x
    3    x     x     x
    and on sheet2 I might have...

         A     B     C
    1    o     o     o
    2    o     o     o
    3    o     o     o
    and these ranges are dynamic, meaning they could be more or less rows (columns are static)

    I would like to have a summary sheet showing the 2 ranges combined sequentially like so...

         A     B     C
    1    x     x     x
    2    x     x     x
    3    x     x     x
    4    o     o     o
    5    o     o     o
    6    o     o     o
    is there any way to do this?

    I have searched online, but haven't found an answer, mainly because I'm not sure exactly how to phrase my search.

    Any help would be greatly appreciated!
    Last edited by Tomkat; 10-08-2010 at 01:56 PM.

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