| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add text to a cell that has a formula
I have a simple question. I have a worksheet that has a list of item
to be purchased that is referenced from another sheet. =Sheet1!E10 What i want to do is keep the link but add text after the formula. My end result should be =Sheet1!E10 & " add some kind of note" How can I set up a macro to add text to the formula and allow the user to keep the link to sheet1? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| bold text of referenced cell show in formula cell | Excel Worksheet Functions | |||
| The result of a formula referring to a cell with formula as text? | Excel Worksheet Functions | |||
| linking a text formatted cell to a formula cell | Excel Discussion (Misc queries) | |||
| select text in cell based on text from another cell, paste the text at the begining of a thrid cell, etc... | Excel Programming | |||
| match cell text with text in formula | Excel Worksheet Functions | |||
Threaded Mode
