Autofill not detecting correct pattern

King Mustard

New Member
Joined
Mar 27, 2017
Messages
15
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?
 

Some videos you may like

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
35,499
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS
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 =
 

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
35,499
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS
Glad to help. :)
 

Watch MrExcel Video

Forum statistics

Threads
1,108,765
Messages
5,524,768
Members
409,600
Latest member
Dunnowhatfor

This Week's Hot Topics

Top