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!!!
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!!!
>.
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks