| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Link to Multiple Cells Within One Cell Including Text
Does anyone know if is possible to link to multiple cells within a single cell?
Example: The total shippable as of {D5} is {D6} with a total on-order of {D7}. The percent of total shippable to total on order is {D8}. Another {D9} ({D10} total) in new orders is needed to reach the {D11} forecast. Please move up future orders and work with credit to release shippable holds as soon as possible. A copy of the shippable hold report is also attached. Thank you, Rob |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Link to Multiple Cells Within One Cell Including Text
="The total shippable as of "&D5&" is "&D6&" with a total on-order of &"D7"&.
The percent of total shippable to total on order is " & ... and so forth if you want formatting - say D5 contains a date ="The total shippable as of "&Text(D5,"mm/dd/yyyy")&" is "&Text(D6,"#,##0")&" . . . -- Regards, Tom Ogilvy -- Regards, Tom Ogilvy "Rob" wrote: Does anyone know if is possible to link to multiple cells within a single cell? Example: The total shippable as of {D5} is {D6} with a total on-order of {D7}. The percent of total shippable to total on order is {D8}. Another {D9} ({D10} total) in new orders is needed to reach the {D11} forecast. Please move up future orders and work with credit to release shippable holds as soon as possible. A copy of the shippable hold report is also attached. Thank you, Rob |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Link to Multiple Cells Within One Cell Including Text
That is awesome and it worked perfectly. Thank you so much for your help.
-- Rob "Tom Ogilvy" wrote: ="The total shippable as of "&D5&" is "&D6&" with a total on-order of &"D7"&. The percent of total shippable to total on order is " & ... and so forth if you want formatting - say D5 contains a date ="The total shippable as of "&Text(D5,"mm/dd/yyyy")&" is "&Text(D6,"#,##0")&" . . . -- Regards, Tom Ogilvy -- Regards, Tom Ogilvy "Rob" wrote: Does anyone know if is possible to link to multiple cells within a single cell? Example: The total shippable as of {D5} is {D6} with a total on-order of {D7}. The percent of total shippable to total on order is {D8}. Another {D9} ({D10} total) in new orders is needed to reach the {D11} forecast. Please move up future orders and work with credit to release shippable holds as soon as possible. A copy of the shippable hold report is also attached. Thank you, Rob |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell including text and multiple formulas? | Excel Discussion (Misc queries) | |||
| count using multiple criteria including text strings | Excel Worksheet Functions | |||
| How to create a link including all formatting from origin cell? | Excel Worksheet Functions | |||
| Add cells including text | Excel Discussion (Misc queries) | |||
| sorting multiple rows at once (including merged cells) | Excel Programming | |||
Linear Mode
