Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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.... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Show actual values added instead of cell references? (=A1+A4 shows as=10+2 in cell) | Excel Discussion (Misc queries) | |||
Show actual values added instead of cell references? (=A1+A4 showsas =10+2 in cell) | Excel Worksheet Functions | |||
Different answers when using cell references as opposed to actual | Excel Worksheet Functions | |||
Replace cell references with names | Excel Discussion (Misc queries) | |||
how to replace cell references with actual numbers | Excel Discussion (Misc queries) |