Inserting information from One Sheet to Many

  • Thread starter Thread starter Buffulo Alice
  • Start date Start date
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
 
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.
 
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
 
Back
Top