Trying to link to cells and then drag autofill to summarise data

%3CLINGO-SUB%20id%3D%22lingo-sub-2769583%22%20slang%3D%22en-US%22%3ETrying%20to%20link%20to%20cells%20and%20then%20drag%20autofill%20to%20summarise%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2769583%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20worksheet%20with%20a%20lot%20of%20text%20and%20numerical%20data%20within.%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EI%20would%20like%20to%2C%20on%20the%20same%20sheet%20or%20another%20tab%20(or%20another%20workbook)%2C%20summarise%20some%20of%20the%20key%20data%20points.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHowever%2C%20after%20I%20create%20the%20cell%20reference%20for%20the%20first%20three%20items%2C%20when%20I%20go%20to%20autofill%20the%20next%20cells%20by%20dragging%20the%20fill%20handle%2C%20it%20does%20not%20learn%20the%20pattern%2C%20and%20creates%20new%20cell%20references.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20the%20attached%20you%20can%20see%20the%20first%20cell%20references%20B5%2C%20then%20below%20is%20F5%20then%20J5.%26nbsp%3B%20However%2C%20when%20I%20drag%20the%20autofill%20down%2C%20the%20next%20cell%20it%20references%20is%20B8.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20checked%20the%20drag%20to%20autofill%20function%20is%20on.%20If%20the%20automatic%20calculation%20function%20is%20ON%2C%20cell%20C60%20references%20B8.%20If%20the%20manual%20calculation%20is%20on%2C%20then%20the%20pattern%20repeats%20starting%20with%20B5%20again%20in%20C60.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20sure%20this%20worked%20in%20the%20past.%26nbsp%3B%20I%20have%20tried%20the%20same%20issue%20across%20tabs%20and%20worksheets%2C%20but%20the%20problem%20persists%2C%20whether%20the%20data%20is%20text%20or%20numbers.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHopefully%20someone%20can%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20using%20a%20Mac%20OS%2011.6%2C%20and%20Excel%20for%20Mac%2016.53.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22cell%20reference%20corrected.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F311751i58325E80207C0DF0%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22cell%20reference%20corrected.png%22%20alt%3D%22cell%20reference%20corrected.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2769583%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2770314%22%20slang%3D%22en-US%22%3ERe%3A%20Trying%20to%20link%20to%20cells%20and%20then%20drag%20autofill%20to%20summarise%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2770314%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1161879%22%20target%3D%22_blank%22%3E%40StunnedPause%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECould%20you%20attach%20a%20copy%20of%20the%20actual%20spreadsheet%3F%20AND%20give%20a%20clearer%2C%20more%20specific%20description%20of%20what%20you%20would%20want%20to%20have%20in%20those%20rows%20beginning%20in%20row%2056%20and%20on.%20All%20you%20have%20said%20is%20%3CEM%3E%22%3C%2FEM%3E%3CSPAN%3E%3CEM%3EI%20would%20like%20to...%20summarise%20some%20of%20the%20key%20data%20points.%22%3C%2FEM%3E%20but%20you%20haven't%20said%20which%20ones.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3ENevertheless%2C%20a%20copy%20of%20an%20actual%20spreadsheet%20is%20FAR%20more%20helpful%20for%20those%20of%20us%20who%20would%20want%20to%20help%20you%20than%20an%20image.%20Fill%20it%20with%20false%20data%20if%20the%20actual%20data%20is%20confidential....%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Frequent Visitor

I have a worksheet with a lot of text and numerical data within.


I would like to, on the same sheet or another tab (or another workbook), summarise some of the key data points.

 

However, after I create the cell reference for the first three items, when I go to autofill the next cells by dragging the fill handle, it does not learn the pattern, and creates new cell references.

 

In the attached you can see the first cell references B5, then below is F5 then J5.  However, when I drag the autofill down, the next cell it references is B8.

 

I have checked the drag to autofill function is on. If the automatic calculation function is ON, cell C60 references B8. If the manual calculation is on, then the pattern repeats starting with B5 again in C60.

 

I'm sure this worked in the past.  I have tried the same issue across tabs and worksheets, but the problem persists, whether the data is text or numbers.

 

Hopefully someone can help.

 

I'm using a Mac OS 11.6, and Excel for Mac 16.53.

 

cell reference corrected.png

 

1 Reply

@StunnedPause 

 

Could you attach a copy of the actual spreadsheet? AND give a clearer, more specific description of what you would want to have in those rows beginning in row 56 and on. All you have said is "I would like to... summarise some of the key data points." but you haven't said which ones.

 

Nevertheless, a copy of an actual spreadsheet is FAR more helpful for those of us who would want to help you than an image. Fill it with false data if the actual data is confidential....