Dynamic named range for columns...moving one column over

Hello. I have a named range. I would like to have this named range automatically update to the right whenever new data is copied into the adjacent column to the right. Let's say I have Data in column A that I named "range". When I add data in the same cells in column B, I would like the range to update to include the cells in A and B (and only the adjacent cells, not the entire column). Is there any way to do this? I've attached a sample spreadsheet. Danks.

Hello amartino44 !!
See the attached file if this helps


if answer is satisfactory Click" * " and mark thread as solved.

name range is Dynamic

@mrice. That formula didn't work. It automatically selects all the way to column E even there is no data in there.

Hello amartino ! I just given a name in name manager and defined a formula for that name. for example i used $B$2:INDEX($B$2:$G$2,0,COUNTA($B$2:$G$2))
where B2 starting point will become a range with C2, D2 or E2 which ever is filled. Index function is providing the column number(E2,C2 etc...) with the help of counta which count how many cells are filled with data. finally it will become a range like B2:C2 etc..
The value error in the sheet is for you to check how formula is working with formula evaluation.
To include more cells in range you just need to change column G2 or G6 or G10 to till you want like z2, Z6, Z10.

If this solves your query, click " * " and mark thread as solved

Ok. This is a good formula but the problem is that I have a range that has 100 cells (down the column), so the formula would enormous if I have to write a section for each cell

can you please upload a sample workbook with enough data to work (sensitive data removed).
I think that also can be done.

Regards
-----------------
if answer satisfiy your requirement, click " * " and mark thread as solved