+ Reply to Thread
Results 1 to 3 of 3

Duplicating cells from different sheets . . .

  1. #1
    Registered User
    Join Date
    07-27-2007
    Location
    Cleveland Ohio USA
    Posts
    3

    Duplicating cells from different sheets . . .

    I need to duplicate certain cells from Sheet1 to Sheet2.
    This can be easly done with =Sheet1!A1
    There are times when I "Cut & Paste" certain rows to different locations on Sheet1, then I get a #REF! error on Sheet2.
    Basically I need Sheet2!A1 to always equal Sheet1!A1 regardless of whether the cell was cut & pasted or moved within Sheet1.

    Any help would be appreciated.

  2. #2
    Forum Expert
    Join Date
    01-12-2007
    Location
    New Jersey
    Posts
    2,127
    Does this work for you:

    =INDIRECT("Sheet1!A1")

  3. #3
    Registered User
    Join Date
    07-27-2007
    Location
    Cleveland Ohio USA
    Posts
    3
    YES!! Thank You

    I wasn't aware of "INDIRECT" function

+ 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