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.
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!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks