Hi,
I have really been struggling with this one !!
I have a range of data in Workbook Called WKBKA
Worksheet Called WKSHTA1 Columns AC & AE and also in Columns Q & S.
I was hoping that in Workbook WKBKB I could perform a fill down function that would take the formula in the first row as shown here '[WKBKA.xls]WKSHTA1'!$AC6
and populate the remaining cells in the fill down range with sequential cells AC7 AC8 AC 9 etc.....
Also in the fill right AD6 AE6 ...etc
It just doesn't seem to want to do it....
Thanks KOSTAS
I have really been struggling with this one !!
I have a range of data in Workbook Called WKBKA
Worksheet Called WKSHTA1 Columns AC & AE and also in Columns Q & S.
I was hoping that in Workbook WKBKB I could perform a fill down function that would take the formula in the first row as shown here '[WKBKA.xls]WKSHTA1'!$AC6
and populate the remaining cells in the fill down range with sequential cells AC7 AC8 AC 9 etc.....
Also in the fill right AD6 AE6 ...etc
It just doesn't seem to want to do it....
Thanks KOSTAS