From: SamZ on
I am looking to carry a balance on one worksheet to the next. I know that the
$ is used but cannot find the format.
From: John on
Hi Sam
I'm not sure what you want but this formula =Sheet1!B20
typed in an other sheet anywhere will bring the information from Sheet1 cell
B20.
You need to change the variable to your needs.
HTH
John
"SamZ" <SamZ(a)discussions.microsoft.com> wrote in message
news:CC8A05F5-5E15-4DA6-9EF6-BBEDBA78A9D1(a)microsoft.com...
>I am looking to carry a balance on one worksheet to the next. I know that the
> $ is used but cannot find the format.