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
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