Do you really mean copy?
In Sheet2 you could have (in any cell) the formula =Sheet!A1 and that would
display whatever value is in A1 of Sheet!
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"DaveO51" wrote in message
...
How do I copy a cell from one sheet to another in the same workbook?