Thread: Make row in one sheet equal column of another
View Single Post
 
Old 03-24-2010, 01:37 PM
ConneXionLost's Avatar
ConneXionLost ConneXionLost is offline Windows XP Office 2003
Simulacrum
  
Join Date: Jan 2010
Location: Victoria, Canada
Posts: 86
ConneXionLost is on a distinguished road
Default
Insert this formula in cell E9 of your destination sheet:

Code:
=INDEX('complaint index'!$G$9:$P$9,1,ROW()-8)
Then autofill down.

Cheers,
Reply With Quote