Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 03-23-2010, 03:52 PM
ConneXionLost's Avatar
ConneXionLost ConneXionLost is offline Make row in one sheet equal column of another Windows XP Make row in one sheet equal column of another Office 2003
Simulacrum
 
Join Date: Jan 2010
Location: Victoria, Canada
Posts: 86
ConneXionLost is on a distinguished road
Default

Hi,

The simplest solution would be to highlight your 'complaint index' range, select copy, then move to your other sheet, select the first cell of your destination column, and use "Paste Special..." with "Transpose".

If you need a formula, please identify the size of the source range and the first cell of your destination column.

Cheers,
Reply With Quote
 

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Make row in one sheet equal column of another 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
Make row in one sheet equal column of another 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 10:57 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft