Make row in one sheet equal column of another

		Microsoft Office Forums > Microsoft Excel > Excel
Make row in one sheet equal column of another

03-24-2010, 01:37 PM

ConneXionLost ConneXionLost is offline

Windows XP Make row in one sheet equal column of another

Office 2003

Simulacrum

Join Date: Jan 2010

Location: Victoria, Canada

Posts: 86

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,

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
If A1 greater than or equal to 1 Then A3 = A2*A1	brians	Excel	5	03-09-2010 12:04 PM
copy cell from sheet 2 to sheet 3 macro	slipperyjim	Excel Programming	1	02-18-2010 01:31 AM
Template for Noting Sheet.	Goldenbird	Word	8	05-25-2009 05:48 AM
sheet linking, sorting	nickbfe	Excel	0	05-19-2006 11:00 AM
Enter Number on any sheet one time only.	paulrm906	Excel	1	04-28-2006 07:35 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:49 PM.