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.
Bookmarks