Hi,
I know how to create a dynamic range that expands vertically in the same column. But, my data starts at cell I5 and is arranged in one row, and I keep adding new data to the side.
I need to create a dynamic named range that expands horizontally.
I appreciate it if someone provided the formula. Thanks