| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Narrative Comment with a Cell Reference
How would I place a cell reference within a narrative comment in another
cell? For example, "Family Practice workload in Jan increased by X%". (This is in a Comments column in the far right-hand side of a spreadsheet). I would like to write a macro to update the month by one and to use the cell reference where "X%" resides to update the narrative comment. Please advise. (I believe "Concantenate" is the key, but I am not sure of the VBA statement). DOUG |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy comment content to cell content as data not as comment | Excel Discussion (Misc queries) | |||
| Print Preview is normal, but numbers do not print, just narrative | Excel Worksheet Functions | |||
| How do I reference a comment in a formula | Excel Discussion (Misc queries) | |||
| Narrative in cells | Excel Discussion (Misc queries) | |||
| problem with cell reference in =sum(offset(cell reference,x,y,z,a)). Want cell ref to be variable. | Excel Worksheet Functions | |||
Threaded Mode
