+ Reply to Thread
Results 1 to 3 of 3

Summarizing/Copying dynamic ranges of data to new sheet?

  1. 10-04-2010, 11:11 AM #1
    Tomkat is offline
    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...

    Please Login or Register  to view this content.
    and on sheet2 I might have...

    Please Login or Register  to view this content.
    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...

    Please Login or Register  to view this content.
    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.
    Reply With QuoteRegister To Reply
  2. 10-04-2010, 10:23 PM #2
    pike is offline
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,342

    Re: Summarizing/Copying dynamic ranges of data to new sheet?

    Hi Tomkat,
    welcome to the forum
    A quick search of the forum return this 
    Please Login or Register  to view this content.
    If the solution helped please donate to RSPCA

    Site worth visiting: Rabbitohs
    Reply With QuoteRegister To Reply
  3. 10-08-2010, 01:53 PM #3
    Tomkat is offline
    Registered User
    Join Date
    03-03-2009
    Location
    Pennsylvania, USA
    MS-Off Ver
    Excel 2007
    Posts
    53

    Re: Summarizing/Copying dynamic ranges of data to new sheet?

    Thanks!

    I figured I'd have to use a macro, and since the beginnings of my dynamic ranges were different on each page, I ended up using the "xltoright" and "xldown" selection functions...

    Here's my code (hopefully someone can tweak it to their needs)

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1