Trying to input data from columns in cell

		Microsoft Office Forums > Microsoft Excel > Excel
Trying to input data from columns in cell

FAQ

Thread Tools

Display Modes

07-31-2013, 02:57 AM

gregjordan38 gregjordan38 is offline

Windows 7 32bit Trying to input data from columns in cell

Office 2007

Novice

Join Date: Jul 2013

Posts: 3

Hi again Pecoflyer,

Finally got it, thanks for the suggestions as even searching under what you suggested helped. Think I had been at it so long my brain was melted.

=INDEX(Sheet1!$A2:A651,COLUMNS(Sheet2!$B1:B1),ROWS (Sheet2!$B$1:B1))

used that code and it works perfectly.

Tags

formula, help please, rows and columns

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to input the text of a cell into another cell automatically ？	Juliet	Excel	1	03-15-2013 03:25 AM
how to input data vertically in spreadsheet?	mikehende	Excel	3	10-10-2012 11:40 PM
how to write G1 in terms of B1+value in the cell 5 columns away (which is G1 itself))	Sunny	Excel	3	04-20-2012 12:32 AM
Data input in Powerpoint?	DeeDubb	PowerPoint	1	04-05-2012 01:53 AM
Move data from 1 cell to another cell	Catalin.B	Excel	1	06-25-2011 12:51 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:34 PM.