Extending a growth pattern in formulas right in rows, instead of duplicating

%3CLINGO-SUB%20id%3D%22lingo-sub-2583427%22%20slang%3D%22en-US%22%3EExtending%20a%20growth%20pattern%20in%20formulas%20right%20in%20rows%2C%20instead%20of%20duplicating%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2583427%22%20slang%3D%22en-US%22%3E%3CDIV%20class%3D%22lia-message-subject-wrapper%20lia-component-subject%20lia-component-message-view-widget-subject-with-options%22%3E%3CDIV%20class%3D%22MessageSubject%22%3E%3CDIV%20class%3D%22MessageSubjectIcons%20%22%3E%26nbsp%3B%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CDIV%20class%3D%22lia-message-body%20lia-component-message-view-widget-body%20lia-component-body-signature-highlight-escalation%20lia-component-message-view-widget-body-signature-highlight-escalation%22%3E%3CDIV%20class%3D%22lia-message-body-content%22%3E%3CP%3E%3CSTRONG%3EDevice%20and%20OS%20platform%3A%26nbsp%3B%3C%2FSTRONG%3ELaptop%20and%20Windows%2010%3C%2FP%3E%3CP%3E%3CSTRONG%3EExcel%20product%20name%20and%20version%20number%3C%2FSTRONG%3E%3A%26nbsp%3BVersion%202106%20(Build%3A%26nbsp%3B14131.20332)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHey%2C%20I%20think%20this%20is%20a%20really%20simple%20request%2C%20and%20probably%20a%20simple%20fix%2C%20but%20I%20think%20I'm%20not%20typing%20the%20right%20questions%20on%20google.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20formula%3A%20%3DMichael!%24C15%2BMatthew!%24C15%2BKassandra!%24C15%2BJulien!%24C15%2BPatrick!%24C15%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20is%20a%20combination%20of%20values%20to%20give%20a%20number%20to%20a%20sales%20head%20in%20my%20company%20as%20a%20weekly%20report.%20I%20realized%20that%20I%20missed%20a%20couple%20values%20after%20copying%20(not%20effectively)%20everything%20over%20from%20each%20individual's%20sheets%2C%20and%20need%20a%20few%20more%20columns%20of%20information%2C%20and%20I%20don't%20want%20to%20do%20it%20again.%20I%20want%20to%20autofill%20to%20the%20cell%20to%20the%20right%20in%20the%20row%20by%20selecting%20the%20cell%20with%20the%20formula%20and%20filling%20right%2C%20but%20it%20just%20copies%20the%20formula.%20I%20can%20do%20it%20by%20dragging%20the%20fill%20header%20down%2C%20which%20does%20what%20I%20need%2C%20but%20I%20need%20it%20to%20do%20it%20within%20the%20row%2C%20to%20the%20right.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20way%20to%20fill%20in%20a%20growth%20pattern%20with%20row%2Fcolumn%20numbers%20to%20a%20cell%20on%20the%20right%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2583427%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2623977%22%20slang%3D%22en-US%22%3ERe%3A%20Extending%20a%20growth%20pattern%20in%20formulas%20right%20in%20rows%2C%20instead%20of%20duplicating%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2623977%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1111801%22%20target%3D%22_blank%22%3E%40nathanasimpson%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20stated%3A%3C%2FP%3E%3CP%3E%3CSTRONG%3EI%20have%20a%20formula%3A%20%3DMichael!%24C15%2BMatthew!%24C15%2BKassandra!%24C15%2BJulien!%24C15%2BPatrick!%24C15%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20information%20is%20in%20%24C15%20is%20it%20a%20number%3F%20a%20date%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eseems%20like%20you're%20adding%20values%20so%20i%20can%20guess%20its%20a%20number%20unless%20you're%20doing%20a%20boolean%20comparison%20(true%20or%20false)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eyou%20can%20simplify%20your%20questions%20by%20not%20using%20your%20company's%20internal%20terminologies%20but%20instead%20use%20laymen's%20terms%20i.e.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20several%20sheets%20relating%20to%20sales%20people%20Column%20A%20is%20blah%20blah%2C%20Column%20B%20is%20blah%20blah%20blah%2C%20and%20Column%20C%20is%20yada%20yada%20yada%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Emy%20formula%20is%20adding%20the%20yada%20yada%20yada%20value%20to%20get%20the%20%5Bhint%20hint%20here%5D%20in%20order%20to%20get%20the%20%5Bhint%20hint%20here%5D%20so%20I%20can%20get%20the%20%5BTotal%20Picture%20Here%5D.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20is%20the%20best%20approach%20in%20order%20to%20get%20to%20the%20%5BBig%20Picture%20Here%5D%20for%20the%20data%20set%20that%20I%20have.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Echeers%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor
 

Device and OS platform: Laptop and Windows 10

Excel product name and version number: Version 2106 (Build: 14131.20332)

 

Hey, I think this is a really simple request, and probably a simple fix, but I think I'm not typing the right questions on google.

 

I have a formula: =Michael!$C15+Matthew!$C15+Kassandra!$C15+Julien!$C15+Patrick!$C15

 

It is a combination of values to give a number to a sales head in my company as a weekly report. I realized that I missed a couple values after copying (not effectively) everything over from each individual's sheets, and need a few more columns of information, and I don't want to do it again. I want to autofill to the cell to the right in the row by selecting the cell with the formula and filling right, but it just copies the formula. I can do it by dragging the fill header down, which does what I need, but I need it to do it within the row, to the right.

 

Is there a way to fill in a growth pattern with row/column numbers to a cell on the right?

 

1 Reply

@nathanasimpson 

 

You stated:

I have a formula: =Michael!$C15+Matthew!$C15+Kassandra!$C15+Julien!$C15+Patrick!$C15

 

What information is in $C15 is it a number? a date? 

 

seems like you're adding values so i can guess its a number unless you're doing a boolean comparison (true or false)

 

you can simplify your questions by not using your company's internal terminologies but instead use laymen's terms i.e.

 

I have several sheets relating to sales people Column A is blah blah, Column B is blah blah blah, and Column C is yada yada yada

 

my formula is adding the yada yada yada value to get the [hint hint here] in order to get the [hint hint here] so I can get the [Total Picture Here].

 

What is the best approach in order to get to the [Big Picture Here] for the data set that I have.

 

 

cheers