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

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


--
Lotus123
------------------------------------------------------------------------
Lotus123's Profile: http://www.excelforum.com/member.php...o&userid=28611
View this thread: http://www.excelforum.com/showthread...hreadid=487454

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 wrote in message
...
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??