Formulas in many Sheets referring to corresponding column in one sheet
I have a workbook with 81 sheets, the last sheet being where all my data is imported into. Cells A1 through A10 of sheet 1 reference cells A1 through A10 of column A of sheet 81. Cells A1 through A10 of sheet 2 reference cells A1 through A10 of column B of sheet 81. In general, cells A1 through A10 of sheet "i" (where i is between 1 and 80) reference cells A1 through A10 of the ith column of sheet 81 (which is named "Import"). In sheet 1, the current formula in A1 is: =IF(Import!A1="",#N/A,Import!A1). In sheet 2, it is =IF(Import!B1="",#N/A,Import!B1), and so on for the other 78 sheets. I simply want to change the IF statement a bit, to the following (using sheet 1 for convenience): =IF(OR(Import!A1="",Import!A1=0),#N/A,Import!A1). I group all 80 sheets together, and change the A1 through A10 on sheet 1, and all the letters of the other 79 sheets change from B, C, ...AZ, etc. to simply A. So all 80 sheets end up referencing that 1st column of sheet "Import", rather than their corresponding column. Isn't there a simple way to make this sort of change without doing it separately to all 80 sheets? Please help if you can. Thanks.
|