Name manager dynamic range
Hello, I would like to setup a dynamic range selection using excel Name Manager. I found this function that almost do the job. The issue i have is that i want to select several columns and not only one. Any idea? Below the found that is working with on column / i did not find a way to select multiple columns: =OFFSET($K$1,1,0,COUNTA($A:$A)-1,1) With this formula used in name manager, I will dynamically sélect all content columns K based on data of column A What to do to select dynamically K to O Columns dynamically? Thank you