VBA IF statement, yes find specific row and edit values, if no insert new line item in table

[Thecraftycarrot]

Hi All,

I am new to VBA so still learning.

What i am trying to do is have an if formula, that when it matched 2 criteria, it searches in a separate tab within a table for the item with that name. it will then update several fields based on what has been completed within the first sheet.

If no, it will then insert a row at the bottom of the table and populate some of the fields based on this.

i have so far got the following:

If Range("G45") = "Yes" And Range("M45") <> "" Then
[U][I]xxxx (search function, looking for cell m45 in sheet 1, to a line item in table in second sheet)[/I][/U] = Sheets("Test1").Range("M45")
[U][I]XXXX(same as above) [/I][/U]= Sheets("Test1").Range("E6")
Else
[I][U]Insert row, then in this newly inserted row copy data from sheet 1 into sheet 2[/U][/I] = Sheets("Test1").Range("E6")

i hope this makes sense

thanks in advance

 

[Thecraftycarrot]

Hi All i have resolved the else ask, but still require some help with the first part?

any response would be appreciated