| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I make multple worksheet text all show in one box as a tot
I am trying to get a cell on my last work sheet to haev all the text values
from 31 worksheets to show in a single box. IE sheet 1 box 1 says W1R, Sheet 2 box 1 says M1R, Sheet 3 says Y1R, I want Total sheet to say, "W1R, M1R, Y1R". Is there a way to have that come up like that? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I make multple worksheet text all show in one box as a tot
You can use CONCATENATE (cell ref1, cell ref2, ...) to join a bunch of cells
values together. -- Tips for Excel, Word, PowerPoint and Other Applications http://www.kan.org/tips "NavyGunner" wrote: I am trying to get a cell on my last work sheet to haev all the text values from 31 worksheets to show in a single box. IE sheet 1 box 1 says W1R, Sheet 2 box 1 says M1R, Sheet 3 says Y1R, I want Total sheet to say, "W1R, M1R, Y1R". Is there a way to have that come up like that? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| searching text and conditional format with multple conditions | Excel Worksheet Functions | |||
| How do I make a plus sign show as text? | Excel Discussion (Misc queries) | |||
| How do I make H = -1 on a worksheet, yet show H? | Excel Worksheet Functions | |||
| how can i make a cell always show text in caps | Excel Worksheet Functions | |||
| Merged Cell will initally show text from 1st worksheet but then wo | Excel Worksheet Functions | |||
Linear Mode
