Previous Topic Next Topic

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
Hello,



I want add rows with say Y1,Y2,Y3...Y10 based on what value the user selects from the drop down i.e. Say a user selects 5 then in the other sheets 5 rows are visible with the heading Y1, Y2...Y5

1 response

Answer 1 / 1
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
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: 
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
0

Similar discussions

How do I change a base location on Instagram?
rebelkids -
38nancy -

8 responses
help me to add particular cells
mathewmunna -
mathew munna -

2 responses
Code for macro that conditionally inserts rows
bfleming -
bfleming -

4 responses
Duplicate rows based on cell value
fireburn -
TrowaD -

16 responses
Facebook says that my email doesn't match my facebook email
@@@@@@@@@@@ -
Ambucias -

1 response