98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Formulas
Formulas
Resolved · Low Priority · Version Standard
Mon 17 Mar 2008, 16:06Delegate Hash said...
Tue 18 Mar 2008, 10:09
Edited on Tue 18 Mar 2008, 10:11Trainer Pete said...
RE: formulas
Hi Hash, Thanks for the post, Welcome to the forum, in answer to your question, this is quite a simple thing to do, in the sheet (Sheet1) active cell that you wish to have the link, place an equals sign (=) and then change to the sheet (Sheet2) you wish to link to using the tabs at the foot of the workbook and select the cell to be linked.
Press Enter and you will see the data in Sheet1 will be exactly that as in Sheet2.
You can create formulas that link worksheets and even workbooks in the same way. I hope that helps, best regards Pete.
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. |
Excel tip:##### displaying in ExcelWhen you get a series of hash symbols (####) appearing in some of your cells in a spreadsheet, this can make you think that you've make some kind of mistake. |
