Search results

Pivot:

Maybe: Private Sub Worksheet_Change(ByVal Target As Range) Dim DVCells As Range Set DVCells = Intersect(Target, Range("Tabela13[Status]")) If Not DVCells Is Nothing Then On Error Resume Next Me.Unprotect For Each cll In DVCells Select Case cll.Value Case "A": VD = "B" Case "B"...

Don't know. When you delete a cell on a protected sheet, the data validation seems to be deleted too, but not on an unprotected sheet.

Attached

I must be missing something big, because having watched the video I can see no earthly reason you might want to do this! What are you trying to do?!

You could do something like: =INDIRECT("Sheet2!" & CELL("address", C2)) but I don't see the point, why not just have: =Sheet2!C2 and copy that down and across? Or a single cell which spills: =Sheet2!C2:E5

Yes, I think you have a version of Excel which supports the worksheet function FILTER, so see cell K5 in the attached...

Another macro approach: A one liner: Private Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Target, Range("G3:I3")) Is Nothing Then Range("B4:D19").AdvancedFilter Action:=xlFilterCopy, CriteriaRange:=Range("G1:I2"), CopyToRange:=Range("G4:I4"), Unique:=False End Sub It uses...

I can do this in Power Query but I'm not good enough with DAX to do it in DAX; would this be any use? Also note that I've added a few test rows to your source data, is the result above what you're wanting (especially the last row)?

1. I can see that one condition is Transaction Type being "Purchase" but I can't determine the 2nd condition; what is it? 2. What version of Excel are you using?

Also, what does this look like in your workbook?: I want to see the whole formula and the Applies to: field.

See query table at cell A22 of the query sheet. You don't really need the right-most column since, by definition, it's a repeat of the CHEQUE AMOUNT column.

You're looking at whole columns in 14 sheets. I don't imagine you have about 1 million rows of data in each month. In the following formula, still inefficient, I've assumed 100 rows per month, and that you have a version of Excel with the functions LET, CHOOSECOLS, TAKE and VSTACK. It should...

No I really need a link to a workbook. A complete guess from your picture:=ARRAYFORMULA(IF(O3:O<>$W$1,"-", IF(P3:P = "", "", IF(ISNUMBER(MATCH($W$1 & P3:P & O3:O, $S$1 & K3:K & J3:J, 0)), "Received", "Missing"))))

Try:=SUMPRODUCT(BYROW(Table1[[Expdiotor]:[Field]],LAMBDA(a,OR($C16=a)))*BYROW(Table1[[EDD first]:[EDD last]],LAMBDA(a,OR(D$15=a))))

It seems to work all right, so the problem is what is the 'correct' result? Difficult to know what needs putting right from something which is giving the wrong result. Probably best to give us some data along with the expected results somewhere and a bit of narrative explaining what it's...

Someone else may chip in…

Very hard work with formulas. Easier with tables, Power Query and Pivot tables. See attached.

With a user-defined-function? See attached in cells H9 and H15.

See attached. Both Sheet1 and Sheet2 have been processed. 1. Add a cell at the bottom of column A with just MZ in it (A26 and A253 in those sheets (green coloured)). 2. See the green cells at Sheet1 B2:J2 and Sheet2 B1:N1. In Excel 2007 you need to be careful how you enter the formula: For...

Perhap the attached?

Would this do the same?: Selection.End(xlToRight).Select Selection.End(xlToRight).Select If not, under what circumstances are you wanting to execute these sendkeys? Another application? A dialogue box? There may be the same thing with quite different code.

This worked for me (I was searching plain values, not the results of formulae): Dim AddOnRange As Range Set AddOnRange = AA04.Range("AD5:AD100") Dim WorksheetRange As Range Set WorksheetRange = AA04.Range("AI5:AI100") Dim MyRange As Range Set MyRange = Union(AddOnRange, WorksheetRange) Dim str...

In AD2: =INDEX(E2:W2,MATCH(TRUE,(F2:X2-D2)>=0,0))copy down. In AE2:=INDEX(E2:W2,AGGREGATE(15,6,IF((F2:X2-D2)>=0,SEQUENCE(,19)),2))copy down.

Try something along the lines of: =CEILING.MATH(A1-6,7)+12 where cell A1 contains the transaction date. (If you don't have the CEILING.MATH function, just CEILING will give you the same result.