I have array range A1:C1, the target cell will be D1. If I select A1:D1 and drag it to the right, the next target cell will be H1 with array A1:G1. I know there is a way base on target cell but I cannot figure it out. Anyone can help?