| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to replace cell references with actual numbers
i need to find a shortcut, maybe a marco to replace the formula the
refers to cell references on another worksheet to dispay actual numbers. For example, I have =sum(Sheet1!B5+Sheet1B4) in sheet2, and i need to have =sum(14+15), where B5=14 and B4=15 in sheet2. please help, i have a really, really long list to work with and wouldn't want to do this by hand.... |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell References | Excel Discussion (Misc queries) | |||
| Completely baffled on what should be simple | Excel Discussion (Misc queries) | |||
| Excel - copy absolute cell references (within the range) as relati | Excel Discussion (Misc queries) | |||
| Using Find & Replace to edit cell references in links | Excel Discussion (Misc queries) | |||
| Adding a row to worksheet does not update cell references in another. | Excel Worksheet Functions | |||
Threaded Mode
