hi,
Answer to first question.
Copy formula then Paste Special Values

Answer to second question.
http://www.cpearson.com/excel/duplic...#InOneNotOther

Regards
FSt1

"Kay" wrote:

I have a workbook which has 3 worksheets. The first (Sheet1) is a manual data
input form. The second (Sheet2) is automatically populated with specific
entries from Sheet1. The final sheet (Sheet3) was created so I could compare
(and therefore highlight via conditional formatting/macro) 'old' data and
'new' data. That is, the information in Sheet2 is current whereas the Sheet3
data is out of date.

I have two problems. First, I want to know how I can actually pull the
values that arise from cell formulae (rather than just the formulae) in order
to create Sheet3 (the 'old' data worksheet used for comparison).

Second, I want to know what macro/conditional format I should use to
highlight changes between Sheet2 and Sheet3. All assistance is greatly
appreciated as always!!