VBA to match cell value

[FaizanRoshan88]

I have excel wb that create Invoices with VBA. i need code to match ActiveWS range("A8") with ws "Breaking_Data" Range("K5 to last cell with value), if cell A8 value match with range value then copy cell value form Range("L5 to last cell with value) to ActiveWS Cell "A9". Like if cell A8 value match with cell K45 then copy cell L45 value to "A9" cell.
I have upload file if any one like to see in detail.

 

[Hui]

You refer to Breaking_Data columns K & L but there is no data in them?

 

[Hui]

If I understand what you want why not just put
=INDEX(Breaking_Data!F5:F268,MATCH(A8,Breaking_Data!A5:A268,0))
in Invoice!A9

 

[FaizanRoshan88]

If I understand what you want why not just put
=INDEX(Breaking_Data!F5:F268,MATCH(A8,Breaking_Data!A5:A268,0))
in Invoice!A9

Thank for tip, but i con't use formula because i use vba to create customer invoice using (Breaking_data) sheet data. every new customer invoice will filled up with their customer address. i upload new excel wb with filled K & L columns
Please see if any way to solve it. Also i need to subtotal for each customer on their invoice, i filled up cell with yellow color that need to solve.