摘要： Refer to http://www.contextures.com/xlDataVal05.htmlRefer to http://www.mrexcel.com/forum/excel-questions/188444-auto-increment-source-range-drop-down-list-box.htmlOne way is to define a 'Dynamic' named range via insert/name/define and use a formula like this instead of a cell reference. The 阅读全文

摘要： Refer to http://www.dummies.com/how-to/content/managing-range-names-in-excel-2010.htmlA range in Excel is a group of one or more cells in a worksheet.A name can be given to a range to make it easier to identify this cell or cells when creating formulas or charts.If you’ve created a number of range n 阅读全文