Hello all,
Im attempting to create a work sheet that will essestially abbriavte the data in another workbook. I'm using the below formula for most of the calculations.
This performs the calculation correctly for a different sheet in the same workbook however I'm struggling to get the code to work when linked to a different workbook. Keep getting a #ref error. Included the code I'm trying to use use below. Thank you for any help you can give.
Im attempting to create a work sheet that will essestially abbriavte the data in another workbook. I'm using the below formula for most of the calculations.
Code:
=AVERAGE(INDIRECT("'Raw Data'!A"&(INT(ROW())-1)*60+5&":A"&(INT(ROW())-1)*60+65))This performs the calculation correctly for a different sheet in the same workbook however I'm struggling to get the code to work when linked to a different workbook. Keep getting a #ref error. Included the code I'm trying to use use below. Thank you for any help you can give.
Code:
=AVERAGE(INDIRECT("' C:\Users\Public[Data Sheet.xls]Raw Data'!A"&(INT(ROW())-1)*60+5&":A"&(INT(ROW())-1)*60+65))
