Example, if i am writing the some character in ("A4") row, it should automatically insert a row in ("A5") and it should keep on continue the same.
Please help in vba coding
Example, if i am writing the some character in ("A4") row, it should automatically insert a row in ("A5") and it should keep on continue the same.
Please help in vba coding
It would be easier to help and test possible solutions if you could attach a copy of your file. Explain in detail what you want to do referring to specific cells, rows, columns and sheets using a few examples from your data (de-sensitized if necessary). See the yellow banner at the top of this page for instructions to attach a file.
You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
Practice makes perfect. I'm very far from perfect so I'm still practising.
"If i am typing text in "D5" row under "Deliverables" , it automatically create a new row ie "D6" row should be added under "Deliverables"
and same for meetings in "D8" and Training "D14"
This was the closest I could get.
If you select the last cell in each section, then a row is inserted.
Enter this code in the worksheet section.
Please Login or Register to view this content.
If character in the active cell is "true" (e.g "D4") or more than one character then need to insert the row as per below code.
how to do that?
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If ActiveCell.Borders(xlEdgeBottom).Color = RGB(68, 114, 196) Then
ActiveCell.EntireRow.Insert
End If
End Sub
You could try:
Please Login or Register to view this content.
Thank you , it' working perfectly !!
when i am adding value in automatically added row, the value is not updating in the total "AJ" column.
Try to incorporate this into the code.
Please Login or Register to view this content.
Thanks , it's working but i can't select more than one cell or one row
OK, just take out:
Cells(Row, Column).Select
This would have gotten you back to the original cell.
Try and experiment a bit.
Yep, Its's working. Thanks again
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks