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 » Excel
Excel
Resolved · Low Priority · Version 2007
Wed 12 May 2010, 16:40Delegate David said...
David has attended:
PowerPoint Intermediate Advanced course
Excel Intermediate course
Excel Advanced course
Visio Introduction course
Excel
how do i use dynamic name ranges?
Question to Newson
Thu 13 May 2010, 10:04Trainer Newson said...
RE: excel
Hi David
You posted this question before I gave you the answer. Dynamic ranges are more of a programming tool however you can name a range of one hundred cells and then sum them on another sheet as entries are added to the list then the other sheet is updated.
sum(namedrange)
Sorry you didn't need a complicated solution as I originally suggested this would work fine.
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:Viewing Many WorksheetsIf there are more worksheets in your workbook than there is room to show all their tabs at the bottom of the screen - Right click on the navigation arrows. A list of all your worksheets is shown. You just click on the one that you want to access. If you have more than 15 worksheets, select in the list and choose your worksheet from hundreds. |
