Hi, good weekend!
I have a very short question. In cell A1 of Sheet2, the value is static text: Sheet1!B:B, which means that it refers to column B of Sheet1. As this is a static text, it will not change even when new columns are added before column A of Sheet1. How do I use a formula to make cell A1 of Sheet2 automatically update when new columns are added in Sheet1? I know named range can make this happen, but I prefer to use a formula to accomplish this.
Thanks!
I have a very short question. In cell A1 of Sheet2, the value is static text: Sheet1!B:B, which means that it refers to column B of Sheet1. As this is a static text, it will not change even when new columns are added before column A of Sheet1. How do I use a formula to make cell A1 of Sheet2 automatically update when new columns are added in Sheet1? I know named range can make this happen, but I prefer to use a formula to accomplish this.
Thanks!