Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Formulas
Resolved · Low Priority · Version 2003
Keith has attended:
Excel Advanced course
How do I link formulas between several worksheets to populate a summary sheet
Hi Keith
Firstly go into your summary sheet and select the cell that you want your formula to appear. Type = and then click through to the sheet the formula appears in and then click on the cell. Finally hit the enter key and the cell in your summary sheet will update automatically with the info in that sheet.
Lets say I wanted the info contained in Sheet 2 cell A1 to be copied into Sheet 1 cell A1 as my summary sheet. My formula in Sheet 1 cell A1 would be : =Sheet2!A1
Hope that helps
David
|
Excel tip:Using Excel's MODE functionUse Excel's MODE function to display the most common value present in a particular range of cells. |
We'll call during UK business hours
Server loaded in 0.09 secs.