Adding rows based on Users selection
Closed
nitin
-
Apr 28, 2014 at 02:03 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Apr 29, 2014 at 11:17 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Apr 29, 2014 at 11:17 AM
Related:
- Adding rows based on Users selection
- Microsoft save as pdf ads on - Download - Other
- Badoo blocked users - Guide
- Based on the values in cells b77 b81 c77 - Excel Forum
- We couldn't find an account matching the login info you entered, but found an account that closely matches based on your login history. - Facebook Forum
- How to insert rows in excel automatically based on cell value without vba ✓ - Excel Forum
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Apr 29, 2014 at 11:17 AM
Apr 29, 2014 at 11:17 AM
Hi Nitin,
Not sure if your question is specific enough, but let's start with the code below and go from there:
Implement code by right-clicking the drop down sheet's tab and selecting View code. Paste the code in the big white field.
Best regards,
Trowa
Not sure if your question is specific enough, but let's start with the code below and go from there:
Private Sub Worksheet_Change(ByVal Target As Range)
Dim x As Integer
If Intersect(Target, Range("A1")) Is Nothing Then Exit Sub
Do
x = x + 1
Sheets("Sheet2").Cells(x, "A") = "Y" & x
Loop Until x = Target
End Sub
Implement code by right-clicking the drop down sheet's tab and selecting View code. Paste the code in the big white field.
Best regards,
Trowa
