Autofill not detecting correct pattern

[King Mustard]

I have a workbook with two worksheets.

Let's call them worksheet AAA and worksheet BBB.

In worksheet BBB, the following information is in the following cells:

A1 ='AAA'!E13
B1 ='AAA'!E14
C1 ='AAA'!E15

When I select the three cells and drag Autofill to D1, I am expecting E16 but it actually shows H13.

Any ideas how I can fix this?

 

[RoryA]

Autofill won't do that with cell references. What you can do is enter zz'AAA'!E13 in A1, then fill across and then use Find/Replace (Ctrl+H) to replace zz with =

 

[King Mustard]

Autofill won't do that with cell references. What you can do is enter zz'AAA'!E13 in A1, then fill across and then use Find/Replace (Ctrl+H) to replace zz with =

That worked a treat - thank you!

 

[RoryA]

Glad to help.