Refering cells between worksheets

[In Need]

I have a Form on one sheet and a summary on the next sheet.

What i want to do is be able to type in text on the form and have it
automatically transfered to the summary e.g. date, description, amounts etc.

Can anyone help??

[Lotus123]

For example:

Instead of sheet1 and sheet2, assume the sheets are named Formsheet and Summarysheet.

Cell A1 of Formsheet has the input data, and you want cell A1 of Summarysheet to have the same data in it.

Type this formula into cell A1 of Summarysheet:

=+Formsheet!A1

[Lisa Beach]

try this --
On the summary sheet type = then click to the form sheet and select the
cell. If you need a sum for example on the summary sheet type =sum(
then click on the form sheet and select the range that you want it to add.
You can do this same thing with other functions like count, average, etc.


"In Need" <In [email protected]> wrote in message
news:[email protected]...
I have a Form on one sheet and a summary on the next sheet.

What i want to do is be able to type in text on the form and have it
automatically transfered to the summary e.g. date, description, amounts etc.

Can anyone help??