I am trying to insert a row that meets a cell criteria into another sheet. When it copies over to the second sheet, it just replaces the first row instead of shifting the cells. Here is my code below. I have the “Selection.Insert Shift:=xlDown” line of code which I thought would shift the cells down before inserting, but it’s not working.<\/p>\n
Private Sub Worksheet_SelectionChange(ByVal Target As Range)<\/p>\n
‘ The code below copies any row with column “B” containing the “Completed”
\n‘ to the “Completed Tasks” sheet.<\/p>\n
Set t = Sheets(“Tasks”)
\nSet c = Sheets(“Completed Tasks”)
\nDim d
\nDim j
\nd = 1
\nj = 2<\/p>\n
Do Until IsEmpty(t.Range(“B” & j))<\/p>\n
If t.Range(“B” & j) = “Completed” Then
\nd = d + 1
\nc.Rows(d).Value = t.Rows(j).Value
\nSelection.Insert Shift:=xlDown<\/p>\n
End If
\nj = j + 1
\nLoop<\/p>\n
End Sub<\/p>\n
Any ideas??<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"inline_featured_image":false,"iawp_total_views":5},"question-category":[53],"question_tags":[],"class_list":["post-14613","question","type-question","status-publish","hentry","question-category-office"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question\/14613","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question"}],"about":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/types\/question"}],"author":[{"embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/comments?post=14613"}],"wp:attachment":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/media?parent=14613"}],"wp:term":[{"taxonomy":"question-category","embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question-category?post=14613"},{"taxonomy":"question_tags","embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question_tags?post=14613"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}