Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help!! using sheet 1 information to change information on sheet 2 | Excel Worksheet Functions | |||
checkbox, then taking information from one sheet to another sheet | Excel Worksheet Functions | |||
Inserting information into a unmade row with a macro | Excel Discussion (Misc queries) | |||
INSERTING INFORMATION IN A CELL | Excel Discussion (Misc queries) | |||
Inserting Filtered RC cell information into other worksheets | Excel Discussion (Misc queries) |