3d references then & autofill
 

trying to refer to cells in different workbooks. can i use a 3d reference to
refer to different workbook and a specific cell THEN use the autofill in
adjacent cells to continue. 3d ref works for one cell but NOT when i use
autofill. copy/paste specials doesn't seem to work either