How do I create a formula in excel to automatically copy text fro.

Need to set up a workbook that copies text from various worksheets in the
workbook into a summary page at the beginning of the workbook. Cannot figure
out the forula to copy one cell of text to another cell automatically -
Please help!!!

hi,
formulas return a value, they cannot perform an action
like copy.
you can have formulas on your summary page that return
values from other parts of your work book.
something like
=sheet1!A1
this formula anywhere on your summary page will return
what ever value is in cell A1 on sheet 2.

>-----Original Message-----
>Need to set up a workbook that copies text from various
worksheets in the
>workbook into a summary page at the beginning of the
workbook. Cannot figure
>out the forula to copy one cell of text to another cell
automatically -
>Please help!!!
>.
>