Microsoft Office Forums - View Single Post - linked cells

Thread: linked cells

View Single Post

Old

04-03-2012, 08:08 AM

JBeaucaire JBeaucaire is offline

JBeaucaire is offline

JBeaucaire uses Windows XP

Windows XP JBeaucaire uses Office 2003

JBeaucaire uses Office 2003

Office 2003

Advanced Beginner

Join Date: Dec 2011

Posts: 51

JBeaucaire is on a distinguished road

Default

No, that's completely different. But you can create a formula that resolves to the same effect as that. On Sheet2 in cell B1, enter this formula, then copy to the right:

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

Reply With Quote