Inserting information from One Sheet to Many
 

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

Inserting information from One Sheet to Many
 

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.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Buffulo Alice" wrote:

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

Inserting information from One Sheet to Many
 

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


"Luke M" wrote:

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.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Buffulo Alice" wrote:

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

Inserting information from One Sheet to Many
 

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

"Buffulo Alice" wrote in message
...
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


"Luke M" wrote:

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.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Buffulo Alice" wrote:

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