I have a several cells I need information in on the same sheet. I tried to do ='Page1'!A1 A1 will be where I input the information. I want when I put the information in A1 to fill in the others cells. I can do this if the cells is on a different sheet. But for some reason if I try to do it on the same sheet it only put the formula in the cell I want the information in.