Copying between Workbooks - and Fill Down issue

[kmarkou]

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

 

[GlennUK]

Take the $ out and see if you can fill as you want.