Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Excel: Combine contents from identical cells on multiple sheets.
How do you combine contents from indentical cells on multiple sheets into one
cell on a different sheet? I am working on a work schedule for partime workers who will each have a sheet assigned to them to enter their name in a cell next to the days they can work. I want their names to then appear in a master calendar in list form under the date they can work for that month. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Excel: Combine contents from identical cells on multiple sheets.
In the master sheet, try a formula like:
='Sheet One'!A1 & " " & Sheet2!A1 & " " & 'Last Sheet'!A1 I've shown [Sheet One] and [Last Sheet] as being between ' ' marks, which you need to use if the sheet names have spaces in them. Not needed if no spaces in the sheet name. Another way to achieve the same thing would be: =CONCATENATE('Sheet One'!A1, " ", Sheet2!A1, " ", 'Last Sheet'!A1) but the CONCATENATE() function does have a limit of 32 things to tie together, the first formula does not have that limit. "Milan" wrote: How do you combine contents from indentical cells on multiple sheets into one cell on a different sheet? I am working on a work schedule for partime workers who will each have a sheet assigned to them to enter their name in a cell next to the days they can work. I want their names to then appear in a master calendar in list form under the date they can work for that month. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I combine multiple Excel sheets? | Excel Discussion (Misc queries) | |||
How do I combine the contents of multiple cells in one cell? | Excel Worksheet Functions | |||
Moving cursor to identical cells across multiple sheets | Excel Discussion (Misc queries) | |||
combine multiple sheets, each sheet has info in different cells | Setting up and Configuration of Excel | |||
How do I combine multiple whooksheets with identical columns | Excel Worksheet Functions |