I would like to create a dynamic range for multiple columns that are
attributed to the same name for a list. The reason for the dynamic range is
that I would like the user to be able to add to the list. If they had other
data that they would like to incorporate into the list.

I am able to make a list of mutliple columns for a single list and there
are multiple entries.

OFFSET(Sheet1!$A$1,0,0,COUNTA(Sheet1!$A:$A),1) is the example they under
create a dynamic range what changes would need to be made to allow this to be
done for multiple columns

Say if the columns that I am interested in are c and d
I have tried the following formula and it does not seem to work. How does
the list appear when it automatically expands does the darkened border expand
around the list.

OFFSET(Sheet1!$C$1,0,0,COUNTA(Sheet1!$C:$D),1)