Copying data from one cell to another automatically

ConneXionLost · #1 06-10-2010, 02:47 PM

I suspect this will (or won't) be useful depending on your context, but give this a try:

Code:

=INDEX($A$2:$A$7,A1,1)

Cheers,

mrphilk · #2 06-10-2010, 11:52 PM

Quote:

Originally Posted by ConneXionLost

I suspect this will (or won't) be useful depending on your context, but give this a try:

Code:

=INDEX($A$2:$A$7,A1,1)

Cheers,

Thanks, this works great, now time to `put it in` he he!

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Is there a way to do this? (automatically enter text based on form data)	TIKKI555	Word	0	05-26-2010 09:21 AM
Copying contents of CDs	trissn	Office	2	02-05-2010 09:27 AM
Worksheet copying?	markg2	Excel	4	01-07-2010 10:08 AM
Auto-populate an MS Word table cell with text from a diff cell?	dreamrthts	Word Tables	0	03-20-2009 01:49 PM
Automatically entering/fill data in cells in Excel 2003	dipdog	Excel	0	08-17-2006 08:37 AM