Hi, can anyone help me with this one??



You have a large amount of 'raw' data on a worksheet (sheet1) and you wish to produce summary information tables on a new worksheet (sheet2). One of these elements of data is on sheet 1 in cell A3. How do you refer to this data on a cell on sheet 2 if you wish to display the value (using the =Value() function) which is originally calulated on sheet 1?


a. =Value(Sheet1.A3)
b. =Value(Sheet1!A3)
c. = Value(Sheet1:A3)
d. =Val(Sheet1!A3)


Thanks for any help and Merry Christmas

GJ