Is there a way to autofill a sereis of Absolute references without using VBA/Macros? My specific problem is I have two worksheets in a workbook. The Column A of Sheet 1 is a list that refers to values in Column A of Sheet 2. However, Sheet 2 must have empty rows deleted without throwing a REF error into Sheet1.
So, the way I have it now is in Sheet1 A1: =IF(Sheet2!$A$1="","",Sheet2!$A$1), which works for cell A1. However, I need A2 to be =IF(Sheet2!$A$2="","",Sheet2!$A$2) and so-on down Column A several hundred times. Is there a way to autofill this formula all the way down Sheet 1 Column A WITHOUT using VBA? (I cannot use VBA because the IT department demands that macros be disabled on ALL machines.)
So, the way I have it now is in Sheet1 A1: =IF(Sheet2!$A$1="","",Sheet2!$A$1), which works for cell A1. However, I need A2 to be =IF(Sheet2!$A$2="","",Sheet2!$A$2) and so-on down Column A several hundred times. Is there a way to autofill this formula all the way down Sheet 1 Column A WITHOUT using VBA? (I cannot use VBA because the IT department demands that macros be disabled on ALL machines.)