hiko-blog https://blog.hatena.ne.jp/hiko-blog/ Hiko.Blog Excel VBA活用術 https://hiko-blog.hatenadiary.com/ VBA Sub A列項目の種類別に、B列項目を取りまとめる() Dim wsSource As Worksheet Dim wsDestination As Worksheet Dim lastRow As Long Dim uniqueValues As Collection Dim cell As Range Dim key As Variant Dim result As String ' ソースシートと宛先シートを指定 Set wsSource = ThisWorkbook.Sheets("Sheet1") ' ソースシートの名前を適切に変更 Set wsDestination = ThisW… 190 <iframe src="https://hatenablog-parts.com/embed?url=https%3A%2F%2Fhiko-blog.hatenadiary.com%2Fentry%2F2024%2F02%2F03%2F140211" title="A列項目の種類別に、B列項目を取りまとめる - Hiko.Blog Excel VBA活用術" class="embed-card embed-blogcard" scrolling="no" frameborder="0" style="display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;"></iframe> Hatena Blog https://hatena.blog 2024-02-03 14:02:11 rich https://hiko-blog.hatenadiary.com/entry/2024/02/03/140211 1.0 100%