View Single Post
 
Old 03-29-2017, 10:36 AM
gebobs gebobs is offline Windows 7 64bit Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

The most robust way would be to use the Format as Table functionality. Each column is implicitly identified as a range per the column header and the reference is automatically updated when records are added. If you would like help setting this up, attach your workbook here.

Otherwise, you can manually update the reference of named ranges with Formula:Name Manager.
Reply With Quote