dragging

Hello, I'm looking to easily drag the sum of certain cells in a different column BUT keeping a specific range, it's hard to explain so i'll show an example... <tbody> A1 A2 A3 A4 A5 A6 A7 A8 B1=SUM(A1:A4) B2=SUM(A4:A7) B3=SUM(A8:A11) And so on... </tbody> Is there any way I can do this by...

Hello, I'm looking to easily drag the sum of certain cells in a different column BUT keeping a specific range, it's hard to explain so i'll show an example... <tbody> A1 A2 A3 A4 A5 A6 A7 A8 B1=SUM(A1:A4) B2=SUM(A4:A7) B3=SUM(A8:A11) And so on... </tbody> Is there any way I can do this by...

Hi I have made my data validation based on a Named Range (thankyou Mr Excel and Youtube) I am now trying to drag it down to populate a range of cells A2:A285 The problem I am having is that it is keeping everything in Cell A2 as I drag down and is not referring to my Named Range. I have...

Really need some help as I have a huge spreadsheet requiring me to manually enter alot of fields with formulas. I am using the formula =COUNTIFS('A1'!C10:F11,Statistics!K5)+(COUNTIFS('A2'!C10:F11,Statistics!K5))+(COUNTIFS('A3'!C10:F11,Statistics!K5)) The full formula is quite long as this...

Hello I have a long nested formula in one tab which refers to data in another tab. When you step into a formula that references data on the same tab the range highlights in blue and, if you want to, you can drag this range to reference other cells. Is this possible when the data being...

I need I drag a simple cell reference through a series of rows AND columns for example... In cell a1 =m1 b1 =m2 c1=m3 A2 =m4 b2 =m5 c2=m6 When I drag it it obviously drags incorrectly. I also tried making m absolute but it still did not drag correctly. I just really don't want to...

Hello, I have searched quite a bit but could not find an answer for my problem. I am using the wonderful code from http://www.doka.ch/Excel3Dscatterplot.htm to represent a 3D chart using the Excel 2D XY Scatter Plot chart. It comes with scroll bars which allow the graph to be interactively...

Hi All, I want to drag a formula without removing the highlighting and other formatting already existing. What would I have to change in the following vba snip Range("AC2:AI2").AutoFill Destination:=Range("AC2:AI2").Resize(lastline), Type:=xlFillDefault Thanks!

I am working on a tool/worksheet that grabs the data from a user-inputted sheet (Sheet 1). The data the user inputs can vary in length, i.e. # rows. The last cell entered by the user is transferred to the first cell in another worksheet (Sheet 2). I want to basically flip the data from how the...

Hello, I've a spreadsheet with multiple sheets called "Obsevations (1)", "Observations (2)" ... "Observations (20)". I need a summary page, and want to copy cell E16 from each of the Observation sheets. I have tried by going: =Observations (1)!$E$16 and dragging, but the reference to the...

Hello Thanks in advance. When I create a formula and reference a cell within a pivot table and then drag that formula down a column or row - it does not automatically adjust for the next cell down or across. It continues to reference the initial cell. Is there a way around this?