Please Need help!!!

[Alpacino]

Hi guys really struggling with this one.

I have a cell (B12) in Sheet1 with a formula =Address(match(A8,A1:A4,0),match(C8,A1:E1,0))

I like to use B12 as a cell reference for a empty table

I like to copy a value from B9 into the cell reference that is displayed in B12.

Could anyone help with VBA code please.

The table is in a different sheet Sheet2

 

[VoG]

Try

Sub Cpy()
Range("B9").Copy Destination:=Sheets("Sheet2").Range(Range("B12").Value)
End Sub

 

[AlphaFrog]

Sub Macro1()
    With Sheets("Sheet1")
        Sheets("Sheet2").Range(.Range("B12").Value).Value = .Range("B9").Value
    End With
End Sub

 

[Alpacino]

Thanks peeps.
Anyone know how to put this into a userform ??

 

[VoG]

With a button on the userform

Private Sub CommandButton1_Click()
With Sheets("Sheet1")
    .Range("B9").Copy Destination:=Sheets("Sheet2").Range(.Range("B12").Value)
End With
End Sub

 

[Alpacino]

Thanks

Can a userform be used to input figures onto a sheet. Is this possible? I also like to use 3 comboboxes in userform.
E.g
Training module :______
Dept:______
Staff name :______
Date : ______

The last one (date) o would like an input box which enters the figure into a different sheet depending on values entered in comboboxes

E.g
Training module: fire
Dept: warehouse
Staff name bill smith
Date 29/04/11

So on sheet(4) the figure would be put in
Name column bill smith
Training column fire
Date training completed 29/04/11

 

[VoG]

Maybe this will help http://www.contextures.com/xlUserForm02.html

Otherwise please start a new thread as the subject is completely different from your original question.

 

[Alpacino]

Thanks for that.
One last question can u link combobox together
For example if combobox1 has a list of depts. If I select a certain Dept combobox 2 will only show names from that Dept ???

 

[VoG]

See if this helps http://www.mrexcel.com/forum/showthread.php?t=91458