running a macro if a set value is present and...

[lrussell5]

Hi All

I think I have a new one, have searched this forum far and wide.. Any help would be highly appreciated!

What I am trying to achieve is for a preset range of data to be copied into a column depending on the value selected from a drop down box.

The below screen shots will hopefully show what I am hoping to achieve (better than I could word).

If possible the forumla/macro would run when a value is selected from the 'No. Colours' drop down, and whatever the number selected will multiply the number of times the range of data is copied over (see the last image)

 

[VorLag]

Well, if you'd like the macro to run automatically, you can right click the tab, select "View Code" and paste this:

Private Sub Worksheet_Change(ByVal Target As Range)
 
    If Target.Address = "$O$2" Then
        UpdateInfo  
End If
 
End Sub

As for getting the actual data, you'd need to create a macro named UpdateInfo that will have if statements to specify where data should be copied from and based on what conditions.

 

[lrussell5]

Thanks for your help VorLag,

I'm afraid I don't quite folow

Where did "$O$2" come from?

I need a macro to run depending on what values are present in D3, i.e.

IF D3 = 1 Then
Updateinfo1
IF D3 = 2 Then
Updateinfo2
IF D3 = 3 Then
Updateinfo3

Could I then program each 'Updateinfo' macro to return the required set of data?

Perhaps a combo box would be a better solution?

Thanks
Lloyd