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 advanced
Excel advanced
Resolved · Low Priority · Version Standard
Chantel has attended:
Excel Intermediate course
Excel Advanced course
Excel advanced
would like to know how to bring data from one sheet across many as I do a board report every quarter and this would be very helpful with thw charts and graphs.
RE: excel advanced
Hi Chantel, I think I may have already answered this question in another post, but if not here is my response. If you wish to link data from one sheet to many others you should consider the single sheet as being your source. In the destination sheets, (can you group them) select the cell/cells that you wish the data to be displayed in and press the equals key (=), navigate to your source sheet and select the cell to be linked. Press Enter key and you will display the information in the destination sheet/s. This data will update as changes are made to the source data, now your destination cells can be used in your graphs. 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:Recovering Unsaved Work in Excel 2010Ever closed your Excel workbook in a hurry without saving your work beforehand? Here's how to get it back. |