Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automatic Formula to Value Conversion
Hi, I have a range of formulas which look up values from another sheet. Once certain formulas evaluate, I would like those to be static. Is it possible to have the formula change to just the value at this point, perhaps by using a macro or some Excel function? The only way right now I know of is to use the Paste Special option and just paste the values. Thanks -- workerboy ------------------------------------------------------------------------ workerboy's Profile: http://www.excelforum.com/member.php...o&userid=34121 View this thread: http://www.excelforum.com/showthread...hreadid=569535 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automatic Formula to Value Conversion
Hey okay, i'll try and be more specific this time, I have 2 sheets. In the first sheet from the range A1:A10000 for example, i want certain data to be filled in. On sheet 2, i'm going to use a simple formula like =IF(Sheet1!A1="Bob", Sheet1!A1,"") in cell A1 in sheet 2 =IF(Sheet1!A2="Bob", Sheet1!A2,"") in cell A2 in sheet 2 etc. Once any cells in the second sheet fill up with values taken from the first sheet, I want to be able to save those corresponding cells as values rather than leave them as formulas, as I don't want anyone who overwrites something in the first sheet (in those specific cells), to change the values previously stored by the formula in the second sheet. Cells that are blank in sheet1 and thus blank in sheet2, should remain as formulas though. Thanks ... hope this helps explaining the problem better -- workerboy ------------------------------------------------------------------------ workerboy's Profile: http://www.excelforum.com/member.php...o&userid=34121 View this thread: http://www.excelforum.com/showthread...hreadid=569535 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is it possible? | Excel Worksheet Functions | |||
Automatic Currency Conversion | Excel Discussion (Misc queries) | |||
How do I stop automatic conversion of text-to-columns in excel? | Excel Discussion (Misc queries) | |||
"Unable to set the Formula property of the Series class" with a tw | Charts and Charting in Excel | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel |