Create Named List (range) based on check list

Pike, thanks for the reply!
I dont understand what you meant in the last sentance, Should I be using this as the formula in the Named range or using it to build a helper column?
Robert

Originally Posted by pike

hi Hammer_757
As you probably know this names range will be dynamic and off one column
=OFFSET(Sheet1!$A$1,0,1,COUNTA(Sheet1!$A:$A),1)
Do have list from x's you would need helper columns to seperate the data