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