Hello. Someone helped me with the great formula to get a range to be dynamic. The problem is that the range only deals with one cell at a time. This would be ok if my initial range had only a few cells but it has a lot more (about 50 non-adjacent cells) Is there any way to get around repeating the snippet of formula for each cell? This is what the formula is =Sheet1!$B$2:INDEX(Sheet1!$B$2:$G$2,,COUNTA(Sheet1!$B$2:$G$2)). So that just refers to row 2, but I have a lot more rows and the formula would be ginormous like Kardashian's behind or Kate Upton's mother melons.