Change prices

[PIsabel]

Hello.
I have a workbook with two sheets: "DC_Orç" and "DC_compostos".
The "DC_orç" sheet is our budget and the "DC_Composto" sheet is where we enter all the costs that help calculate the sales prices of our items (reference, description and price) and is therefore a kind of database for that budget .
Catalog items are also included in the budget, with references, descriptions and supplier prices.
As prices change almost daily, sometimes we have to change customer prices
What I've achieved so far is this macro that updates all PVPs.
What I need is for this macro to only change the items that were created in the "DC_compostos" worksheet.
someone help me?

Sub Dc_muda_pvp()

    'muda formulas coluna PVP
    Sheets("DC_Orç").Select
    Dim g As Range
    For Each g In Range("G10:G" & Range("B" & Rows.Count).End(xlUp).Row)
        g.Select
        If g <> "" Then
        g = "=IFERROR(VLOOKUP(RC[-5],DC_Compostos!C[-6]:C[-1],6,0),"""")"
        DoEvents
    End If
    Next g

End Sub

 

[mumps]

It is hard to work with a picture. It would be easier to help if you could use the XL2BB add-in (icon in the menu) to attach screenshots (not pictures) of your sheets. Alternately, you could upload a copy of your file to a free site such as www.box.com or www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given alink to the file that you can post here. Explain in detail what you want to do referring to specific cells, rows, columns and sheets using a few examples from your data (de-sensitized if necessary).

 

[PIsabel]

I solved it

 

[smozgur]

I solved it

Good to hear you solved it.

If you would like to post the solution then it is perfectly fine to mark your post as the solution to help future readers. Otherwise, please do not mark a post that doesn't contain a solution.