software

Can I automatically transfer cell values from one sheet to another within the
same file?

Enter following formula with desired sheet name and cell reference
='My Sheet'!A1

HTH
--
AP
quot;Jimquot; gt; a écrit dans le message de news:
...
gt; Can I automatically transfer cell values from one sheet to another within
gt; the
gt; same file?
Not 100% sure what you mean by automatically transferring, you can go into
your 2nd sheet and double click the cell type = and then go to the 1st sheet
and click on the cell you want to update from. you should end up with
something that looks like this in the 2nd sheet cell =Sheet1!A1 This cell
will then display whatever is in A1 and will change as you change the value
of A1 in sheet 1

quot;Jimquot; wrote:

gt; Can I automatically transfer cell values from one sheet to another within the
gt; same file?