I'm currently doing a formula to copy over data from sheet 1 to sheet 2. Currently I'm using =sheet1!j3 to copy the information onto sheet 2 d3. Then =sheet1!j4 for sheet2 d4, and so on. I have to do this for about 400 rows and will have to do it for other columns later. Is there a quicker way of doing it so I don't have to do this for each row. (As in a generic formula I can put in for the whole column)