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
- 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
- Based on the values in cells b77 b81 c77 - Excel Forum
- Cmd send message to all users on network - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
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