Get instant live Excel expert help to learn how to find range in Excel

Trying to work out how to sum the qty and £ sales of a range of products by a range of customer by each calendar month.

I found this macro on this website and it does exactly what I need it to do with the exception of I need to copy it down for all the rows in my spreadsheet and all sheets. Can anyone help me with that? Private Sub Worksheet_Change(ByVal Target As Range) If Intersect(Range("A1"), Target) Is Nothing Then Exit Sub [B1] = [B1] + [A1] End Sub

Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 6 Then Range("J" & Target.Row) = Range("J" & Target.Row) + Range("F" & Target.Row) End If End Sub

I am new to VBA Excel so be kind :-) This is my code. I am getting a syntax error. The line that it stops at is the first ElseIf line. When I first created that line it had three Ands in it and then I read something that said that won't work. Also those four application lines I added bec someone on line said that it helps run the code faster. Not sure if I need it. Sub CallScreeningProficiencyLevel() Application.ScreenUpdating = False Application.Calculation = xlCalculationManual If Range("f3").Value = "No" Or Range("g3").Value = "No" Then Range("b11").Value = "Novice" Elself Range("f3").value = "Yes" And Range("g3").value = "Yes" Then If Range("d9") > 3 And Range("b9") = 0 Then Range("b11").Value = "Expert" Elself Range("f3") = "Yes" And Range("g3") = "Yes" And Range("d9") < 4 Then If Range("b9") = 0 Then Range("b11).value = "Effective" Else: Range("b11").Value = "Novice" End If Application.ScreenUpdating = True Application.Calculation = xlCalculationAutomatic End Sub

Rate Start Date = 05/01/2011 Rate End Date = 31/05/2017 Declaration Date From = March-17 Declaration Date To = May-17 Volumes = 69 Rate = 0.20p I need a formula that will calculate volumes * Rate, but only if the declaration dates are within the rate start and end date range please

I need a formula that identifies wheter a truck is within a certain range of weight carrying capacity (1-3.5 tons, 4-7…) and if it is, then multiply it by its correspondent value. An example would be: WU710L-HKMQJ3 is within the 4-7 ton range, therefore cells D6, F6, H6, J6, L6 and N6 should be multiplied by E2, G2, I2, K2, M2, O2

i want to send a number i select from range of numbers to the bottom and shift cells up

Looking for formula to determine a text continuous occured in range for 3 times or more

Previosly chat with expert but not lost session without get know answer of formula chat details below Welcome 13:25Please explain which Text occurrence in a range you want to count? 13:26As I have mentioned that From Range C to N If Continously Needs Improvement or Poor Text found in a row excluding Blank cells then It should reflect as True in Column B 13:29true only if text (Needs Improvement or poor) should be occured three times or more in a range. 13:31Else it should return FALSE. Right? 13:32ya exactly 13:32Okay 13:32Let me fix it 13:3

how can i create a constant Message Box showing the conditions satisfied in cell range"T" And The Message box will refresh the data as and when conditions met in range"T"