Newbie and Excel 2007 basic question

**light** · 08-09-2006, 01:02 PM

Using R1C1 style.Excel 2007 Beta

Have data in sheet 1. 100 rows of names. Data for each name is offset in 1500 columns but still in the same row as the name. Sheet 2 has the corresponding names from sheet 1.

First name on sheet 2 is in R2C1. Want to fill in R2C2 with data located in Sheet 1 R1C766:R1C775,but want to pick only 1 of those 10 cells of data to extract. Then copy and paste that data into sheet 2 R2C2. Then go to next name down the list in Sheet 2, repeat process till all names complete. I figure I need an input box to ask me which of the 10 cells I want to use as each name is called,but too inexperienced.