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!!! . |
All times are GMT +1. The time now is 04:17 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com