Copy Info from cell to another sheet
Perfect thank you
"Elkar" wrote:
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
|