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.... |
All times are GMT +1. The time now is 08:07 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com