To create a dynamic range for multiple columns attributed to the same name for a list, you can use the following formula:

Here, we have used the COUNTA function to count the number of non-empty cells in column C and included a width of 2 to include both columns C and D.

1. When the user adds data to the list, the range will automatically expand to include the new data.
2. The darkened border will expand around the list to show the new range.

Note that you can adjust the starting cell reference (Sheet1!$C$1) to match the starting cell of your list and adjust the column reference (Sheet1!$C:$C) to match the column range of your list.