View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] famehunter@gmail.com is offline
external usenet poster
 
Posts: 7
Default 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....