On sheet "two" cell A1, enter the formula:

=one!A1

This will return the contents of cell A1 on the sheet called "one". Note
that this is not the same as "Copying", as any changes made to sheet one will
automatically be reflected on sheet two. Is that what you're looking for?

HTH,
Elkar


"Jeremy" wrote:

I just had the biggest brain fart. I have a worksheet I am trying to copy
all of the data from one to the other using a formula. The work sheet with
the data is called one where the one that I am trying to write a formula to
copy it to is two. When I do sum it makes the name 0. Example below

Thank you

Ex
A B C D
1 0012 Bob Tiffany
2 0026 Brandy Frank
3
4