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

I

ijgolding

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!!!
 
G

Guest

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