Bringing in data

[owe97001]

I have a quick question--
I have one spreadsheet that has a list of a 50 names running horizontally from column A to column AZ all in the same row.

What I am wondering is if there is a formula in Excel that will allow me to anchor the cell in Column A and as I copy the formula down in my one spreadsheet I want it to read across in the other sheet and bring in all of those names.

Any suggestions?

Seth

 

[Aladin Akyurek]

See my reply to Captain Smith's question in:

http://www.mrexcel.com/board2/viewtopic.php?t=76043