Results 1 to 4 of 4

Referencing a Moving Range on One Worksheet in Another Worksheet

Threaded View

  1. #1
    Valued Forum Contributor SDruley's Avatar
    Join Date
    04-27-2009
    Location
    Conover, NC
    MS-Off Ver
    Excel 2010 64 bit
    Posts
    415

    Smile Referencing a Moving Range on One Worksheet in Another Worksheet

    I have two worksheets A and B
    Worksheet A has a range of values as follows:
    R S
    4 2.1 3.1
    5 1.9 3.2
    6 2.4 3.9
    7 2.3 3.6

    The above range has an INDIRECT REFERENCE as follows R4:S7 stored in cell W1
    As data is added to columns R and S, the INDIRECT reference may read, for example,
    R21:S24, so, we are keeping track of the last 4 sets of numbers.

    How can I get this moving range of numbers to appear in a fixed location somewhere in Worksheet B? My repeated attempts have only brought over zeros.
    Last edited by SDruley; 01-28-2011 at 02:44 AM.
    Turn Data into Information
    Turn Information into Knowledge
    Turn Knowledge into Direction
    Turn Direction into Leadership
    Turn Leadership into Results
    Stephen Druley

    It's not how quickly you think
    But how deeply you think
    The quality of thinking is measured
    by remoteness to conformance
    Stephen Druley

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