Data Extraction Help

[Joneye]

I have a workbook which is automated. I click a cell information drops in from a table as I choose a product.

What I need to do is collect the info as an end result i.e. the answer after clicking data is in cell A1, id like this to be taken from A1 then to a different tab and stay there and not change when I change the drop down box in the previous tab.

I hope this makes sense?

 

[VoG]

Try this: right click the sheet tab, select View Code and paste in

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address(False, False) = "A1" Then Target.Copy Destination:=Sheets("Sheet2").Range("A" & Rows.Count).End(xlUp).Offset(1)
End Sub

Change Sheet2 to the name of the sheet where you want a copy.

 

[Joneye]

I will do, many thanks. Any issues Ill pop back a reply.

Again many thanks in advance.