Double click cell on one worksheet, copy to another cell on different worksheet

[ssauk]

Hi All,
Although I have been using Excel for years, I am new to the developer side of it.

I am looking for assistance with a problem I have with a project I have done for my wife's shop.
The project is an invoice workbook I have designed which is working great, but I have been asked to improve it slightly.
The workbook has 4 worksheets in it, Customer, Products, Invoice and Register.
I am wanting to be able to double click a cell in column A on sheet Products and have this value enter into a cell on the sheet Invoice, I have managed to do this and it populates the cell A13, but once it has done this when I double click on another cell in column A on worksheet Products, I need it to move down to cell A14 on the worksheet Invoice and so on. At present what I had done will only keep changing the cell A13. I have deleted it all as I just cannot seem to get my head around this.
Hope I have explained it well enough for anyone to understand.

Thanks in advance
Daz

 

[ssauk]

Thanks for this
I had been playing with the code and come up with this ;
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)

If Target.Column = 1 Then
On Error Resume Next
Application.ScreenUpdating = False
Sheets("Invoice").Unprotect Password:="****"
Target.Copy Sheets("Invoice").Range("A13:A31").SpecialCells(xlBlanks)(1)
Sheets("Invoice").Protect Password:="****"
On Error GoTo 0
Cancel = True
End If
End Sub
But will change it to your code.
Thankyou so much for the help

 

[Fluff]

You're welcome & thanks for the feedback

 

[ssauk]

Hi Fluff
All works perfect

 

[Fluff]

?