I have an Excel spreadsheet that has 350 rows with 31 columns of information and I need to print each row separately. I only need the information from 23 of the columns to be printed on each page. I created a new spreadsheet listing the 23 column names and then in the cell underneath it, I linked to the source cell by using the formula =sheet1!a2 and so forth for each cell that I want to copy over. The information linked over correctly for the first row. The problem I have is that if I delete the first row on the source sheet (row 2), the destination sheet shows errors in all the formula cells. I was hoping that when I delete row 2, row 3 then becomes the new row 2 and the new information would be copied to the destination cells. That did not happen. Is there a different formula to use to accomplish this without having to cut and paste each cell?
September 3, 2008 7:16 PM
September 5, 2008 11:58 PM