The attached has some of the kinks kinda worked out.
Still need a bit of help on the VBA syntax for INDEX MATCH
I need to convert:
INDEX(Sheet1!$P:$P,MATCH(Sheet1!$C$3&"|"&Sheet1!$D$5,Sheet1!$N:$N,0),1):INDEX(Sheet1!$P:$P,MATCH(Sheet1!$C$3&"|"&Sheet1!$D$5,Sheet1!$N:$N,0)+COUNTIF(Sheet1!$N:$N,Sheet1!$C$3&"|"&Sheet1!$D$5)-1,1)
to VBA.
I tried this:
WorksheetFunction.Index(ActiveSheetRange("P:P"), WorksheetFunction.Match(Me.TextBox1.Value & Chr(124) & Me.DEPCity.Value, ActiveSheetRange("N:N", 0), 1) & Chr(58) & WorksheetFunction.Index(ActiveSheetRange("P:P"), WorksheetFunction.Match(Me.TextBox1.Value & Chr(124) & Me.DEPCity.Value, ActiveSheetRange("N:N", 0) + WorksheetFunction.CountIf(ActiveSheetRange("N:N"), Me.TextBox1.Value & Chr(124) & Me.DEPCity.Value) - 1, 1)))
but am getting compile error Sub or Function not defined.
Been struggling with this since 6am. I have no idea of what I am doing. HELP!
George
Bookmarks