98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Excel
Excel
Resolved · Low Priority · Version Standard
Chantel has attended:
Excel Intermediate course
Excel Advanced course
Excel
how do we feed data from one sheet to another
RE: excel
Hi Chantel, Thank you for your post, in answer to your question, the most straighforward way of linking data from one sheet to another is to use the equals sign (=) in your destination cell, then navigate to the cell you wish to link to (source), select it and press the enter key. This now ensures that any data in the source cell will be displayed and is available to be used in any formulas or functions from the destination cell. Note any changes made in the source cell will be reflected in the destination. 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:How to Spell Check an Excel 2010 WorksheetExcel 2010 does not automatically spell check a document. So, here's how to manually spell check a worksheet. |