Refering cells between worksheets

I

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??
 
L

Lotus123

For example:

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

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

Type this formula into cell A1 of Summarysheet:

=+Formsheet!A
 
L

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.


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??
 
Top