How to find where formula is populated from

[Vack]

I have a spreadsheet that runs a query and returns data from a SQL database in columns A through F.
In Column G an Excel formula is populated which refers to columns A through F to give you a value.

How do I find where that formula is coming from? I need to make a change to it so that next time the sheet is refreshed it pulls in the changed formula?

When the sheet is blank and you click into the cells in column G there are no formulas. So it seems to only populate when the data is refreshed.

[protonLeah]

Try right clicking the tab name and choose "view code". It may be a worksheet change event macro.

[Vack]

This is all I see.

Private Sub CommandButton1_Click()
Call Enter_PO_data
End Sub

[protonLeah]

On the righthand side of the VBA window is the Project Pane. There should be several modules there. You will have to check each one for the procedure Enter_PO_data. It's hard to tell without a sample workbook, though.