Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel

Excel

ResolvedVersion 2007

Wed 12 May 2010, 16:40 Delegate 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:04 Trainer 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 courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Creating custom lists

In Excel if you type in January in a cell, you can then copy this cell to replicate Febraury, MArch, April etc.

This list has come from Tools- options and Custom lists.

Therefore to save time and create your own list you can click on New (in Tools and custom list tab) and type out the lsit that you want copied quickly.

All you have to do is then type in the 1st word and you will be able to copy the rest of the list quickly.

View all Excel hints and tips

Excel

Excel

RE: excel

Excel articles

Excel tip:

Creating custom lists