Bekijk de onderstaande video om te zien hoe je onze site als een web app op je startscherm installeert.
Opmerking: Deze functie is mogelijk niet beschikbaar in sommige browsers.
Privacywetgeving
Het is bij Helpmij.nl niet toegestaan om persoonsgegevens in een voorbeeld te plaatsen. Alle voorbeelden die persoonsgegevens bevatten zullen zonder opgaaf van reden verwijderd worden. In de vraag zal specifiek vermeld moeten worden dat het om fictieve namen gaat.
Sub export_functie_groepen()
With Sheets("Export")
.Cells.Clear
Sheets("Invulblad").Select
Range("B1").Select
Range("B1000").End(xlUp).Offset(0, 0).Select
laatste = ActiveCell.Row
Sheets("Export").Select
Range("A1").Select
For i = 1 To laatste + 1
ActiveCell.Formula2R1C1 = _
"=IF(Invulblad!R[5]C[1]="""","""",Invulblad!R[5]C[1]&"", ""&TEXTJOIN("", "",,IF(Invulblad!R[5]C[2]:R[5]C[16]=""x"",Invulblad!R1C3:R1C17,"""")))"
ActiveCell.Offset(1, 0).Select
Next i
Columns(1).SpecialCells(xlCellTypeBlanks).Delete
End With
End Sub
Columns(1).SpecialCells(xlCellTypeBlanks).Delete
Sub VenA()
ar = Sheets("Invulblad").UsedRange
Set d = CreateObject("Scripting.Dictionary")
For j = 6 To UBound(ar)
For jj = 3 To UBound(ar, 2)
If LCase(ar(j, jj)) = "x" Then c00 = c00 & "," & ar(1, jj)
Next jj
d(ar(j, 2)) = ar(j, 2) & IIf(Len(c00), ", " & Mid(c00, 2), "")
c00 = ""
Next j
With Sheets("Export")
.Cells.Clear
.Cells(1).Resize(d.Count) = Application.Transpose(d.items)
End With
End Sub
Sub VenA()
ar = Sheets("Invulblad").UsedRange
Set d = CreateObject("Scripting.Dictionary")
For j = 6 To UBound(ar)
For jj = 3 To UBound(ar, 2)
If LCase(ar(j, jj)) = "x" Then c00 = c00 & ", " & ar(1, jj)
Next jj
d(ar(j, 2)) = ar(j, 2) & IIf(Len(c00), ", " & Mid(c00, 2), "")
c00 = ""
Next j
With Sheets("Export")
.Cells.Clear
.Cells(1).Resize(d.Count) = Application.Transpose(d.items)
End With
End Sub
Sub export_functie_groepen()
With Sheets("Export")
.Cells.Clear
End With
ar = Sheets("Invulblad").UsedRange
Set d = CreateObject("Scripting.Dictionary")
For j = 6 To UBound(ar)
For jj = 3 To UBound(ar, 2)
If LCase(ar(j, jj)) = "x" Then c00 = c00 & ", " & ar(1, jj)
Next jj
d(ar(j, 2)) = ar(j, 2) & IIf(Len(c00), "," & Mid(c00, 2), "")
c00 = ""
Next j
With Sheets("Export")
.Cells.Clear
.Cells(1).Resize(d.Count) = Application.Transpose(d.items)
End With
'lege regels verwijderen
Sheets("Export").Select
Columns(1).SpecialCells(4).EntireRow.Delete
End Sub
Sub M_snb()
sn = Sheets("Invulblad").UsedRange
For j = 6 To UBound(sn)
For jj = 3 To UBound(sn, 2)
sn(j, jj) = Replace(sn(j, jj), "x", sn(1, jj), , , 1)
Next
sn(j - 5, 1) = Replace(Application.Trim(Join(Application.Index(sn, j))), " ", ", ")
Next
With Sheets("Export")
.Cells.Clear
.Cells(1).Resize(UBound(sn) - 5) = sn
End With
End Sub
d(ar(j, 1)) = ar(j, 1) & "; " & ar(j, 2) & "; " & ar(j, 2) & IIf(Len(c00), "," & Mid(c00, 2), "")
ar = Sheets("Invulblad").UsedRange
Set d = CreateObject("Scripting.Dictionary")
For j = 6 To UBound(ar)
For jj = 3 To UBound(ar, 2)
If LCase(ar(j, jj)) = "x" Then c00 = c00 & ", " & ar(1, jj)
Next jj
d(ar(j, 1)) = ar(j, 1) & "; " & ar(j, 2) & "; " & ar(j, 2) & IIf(Len(c00), "," & Mid(c00, 2), "")
c00 = ""
Next j
With Sheets("Export")
.Cells.Clear
.Cells(1).Resize(d.Count) = Application.Transpose(d.items)
End With
d(ar(j, 1)) = ar(j, 1) & "; " & ar(j, 2) & "; " & ar(j, 2) & IIf(Len(c00), "," & Mid(c00, 2), "")
d(ar(j, 1)) = ar(j, 1)
d(ar(j, 2)) = ar(j, 2)
d(ar(j, 3)) = ar(j, 2) & IIf(Len(c00), "," & Mid(c00, 2), "")
Sheets("Export").Select
Columns("A:A").Select
Selection.TextToColumns Destination:=Range("A1"), DataType:=xlDelimited, _
TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=True, _
Semicolon:=True, Comma:=False, Space:=False, Other:=False, FieldInfo _
:=Array(Array(1, 1), Array(2, 1), Array(3, 1)), TrailingMinusNumbers:=True
Range("A1").Select
We gebruiken essentiële cookies om deze site te laten werken, en optionele cookies om de ervaring te verbeteren.