+ Reply to Thread
Results 1 to 2 of 2

Excel 2007 : formulae for copying data from column in one sheet into rows in another sheet

  1. 06-17-2011, 09:59 AM #1
    mike.nkhata
    mike.nkhata is offline
    Registered User
    Join Date
    06-17-2011
    Location
    Lilongwe, Malawi
    MS-Off Ver
    Excel 2007
    Posts
    1

    Smile formulae for copying data from column in one sheet into rows in another sheet

    Ladies and gentlemen. I would like to be assisted what formalue I can use for linking cells in one column in a sheet to cells in a row in another sheet. for example I have sheet1 column A 1:1000 to be linked to sheet 2 row1 A:ALM. So that when ever data in sheet1column A1:1000 changes data in sheet2 row1 A:ALM also changes. Eg if I change data in column A cell 1 data in row1 cell A also changes, ColumnA cell 2 changes row1 column B (mind you two different sheet in one work book.
    Reply With QuoteRegister To Reply
  2. 06-17-2011, 04:18 PM #2
    Paul
    Paul is offline
    Forum Expert Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,885

    Re: formulae for copying data from column in one sheet into rows in another sheet

    Hi Mike, and welcome to the forum.

    On sheet2 in cell A1 put the following formula and fill to the right:

    =INDEX(Sheet1!$A:$A,COLUMN(A1))

    Hope that helps!
    - Paul

    Click here to read the Forum Rules

    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