Скачать или смотреть Create Dynamic Named Ranges in Excel which go Left-Right Across Columns

http://www.TeachMsOffice.com
This Excel video tutorial shows you how to make a named range within Excel dynamic. This means that whenever you add something or subtract something from a list in Excel, which is referenced by a named range, that named range will automatically update and change to reflect the new list. This is a great way to automate your spreadsheets and to save you time when working with large spreadsheets in Excel.

This tutorial shows you how to make a dynamic named range which goes from left to right across multiple columns within Excel.


To get the spreadsheet used here of for more excel video tutorials, macros, tips and tricks, visit the website http://www.TeachExcel.com You can also visit the forum there if you have any questions.

Have a great day!