say you want A1 in sheet2 to show the value of A1 from sheet1 then
use the below formula in Sheet2 A1
=Sheet1!A1

-kc
*Click YES if this helps


"laurah" wrote:

I have a spreadsheet with 2 tabs and I need the values from the first sheet
to automatically fill in on the 2nd sheet. what is the formula to share cell
values from one tab to another?