Inserting information from One Sheet to Many

B

Buffulo Alice

I have a workbook with 150 sheets. My first sheet is a list of places. I
would like to take that list and have each cell become fill into cell C5 in
all the other sheets. Is this possible without going through and typing each
name from my list. Thanks for your help
 
L

Luke M

How big is this list?
If using XL 2003 or older, must be 30 or less. If 2007, you're oky. Coult
try this:
Select all 150 sheets (use Shift to select)
In cell C5,
=Sheet1!A1&Sheet1!A2&Sheet1!A3&.......

and so on.
 
B

Buffulo Alice

I may be missing understanding something but when i go ahead and do this i am
just getting the words that i typed in and not the date from the first sheet
 
D

David Biddulph

My guess is that the cell is formatted as Text. Format it as General, then
re-enter the formula.
 
Top