Paste details from one sheet to last line of table in another sheet

[hoonose]

Hello

I've created a sales invoice with data validation search bar to filter my customer details from a table located on the adjacent protected sheet/tab.

What I would love to do, is to have an option to add a new customer to the last row of my table using a very simple copy and paste.

My sheet layout is Invoice / Data
I'd like new details to be entered on Invoice sheet in cells N3 to N8. After pasting to table I would like the text from N3 to N8 to be cleared.
Table starts on Data sheet from column C to column H

I've tried to mix and match codes from various solutions online, add new row and copy paste data but only ended up getting confused.

Would appreciate any assistance on this matter.

 

[mrshl9898]

Hello,

Perhaps:

Sub makeso()

Dim sht As Worksheet
Dim sht2 As Worksheet
Dim LastRow As Long

Set sht = Sheets("Data")
Set sht2 = Sheets("Invoice")

LastRow = sht.Cells(sht.Rows.Count, "C").End(xlUp).Row

sht.Cells(LastRow + 1, 3) = sht2.Cells(3, 14)
sht.Cells(LastRow + 1, 4) = sht2.Cells(4, 14)
sht.Cells(LastRow + 1, 5) = sht2.Cells(5, 14)
sht.Cells(LastRow + 1, 6) = sht2.Cells(6, 14)
sht.Cells(LastRow + 1, 7) = sht2.Cells(7, 14)
sht.Cells(LastRow + 1, 8) = sht2.Cells(8, 14)

sht2.Range("N3:N8").ClearContents

End Sub