Microsoft Office Forums - View Single Post - [Solved] Copying data from one cell to another automatically

Thread: [Solved] Copying data from one cell to another automatically

View Single Post

Old

06-10-2010, 02:47 PM

ConneXionLost ConneXionLost is offline

ConneXionLost is offline

ConneXionLost uses Windows XP

Windows XP ConneXionLost uses Office 2003

ConneXionLost uses Office 2003

Office 2003

Simulacrum

Join Date: Jan 2010

Location: Victoria, Canada

Posts: 86

ConneXionLost is on a distinguished road

Default

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,

Reply With Quote