Forum home » Delegate support and help forum » Microsoft Access Training and help » access course microsoft training - Copying formula to other worksheets
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
access course microsoft training - Copying formula to other worksheets
Resolved · Low Priority · Version Standard
Reply Thu 2 Aug 2007, 09:55Delegate Jean-paul said...
Jean-paul has attended:
Excel Introduction course
Excel Intermediate course
Excel Advanced course
Copying formula to other worksheets
How to copy figures to other worksheet without losing the formula?
For upcoming training course dates see: Pricing & availability
RE: Copying formula to other worksheets
Hi Jean-Paul, Thanks for the post, I guess this is really an Excel question, so here goes, If the two spreadsheets are consistent (exactly the same) you can copy the cell that holds the formula and then paste it into the same cell in the new worksheet, it will retain its formula and relative reference. If however you just need it to look at the same cells in the original spreadsheet but provide the answer in the new spreadsheet, then in the target cell place an equals sign (=) and navigate to the cell with the formula, select it and press the enter key. Hope that works..
|