hello i have some problem of showing the equations of the cells as it only shows the actual values. im not sure if a formula function is need in order to be able to show the equation. my codes are bellow.
Code
For LoopRow = 4 To LastRow
SearchItemPN = Cells(LoopRow, 1).Value
'Find row # of SearchItemPN in SuperBOM sheet
FoundRow = Application.WorksheetFunction.Match(SearchItemPN, Worksheets("SUPERBOM").Columns(1), 0)
'MsgBox "SearchItemPN = " & SearchItemPN
'MsgBox "FoundRow = " & FoundRow
'For loop go through every FGI
For LoopColumn = 3 To LastColumn
SearchFGIPN = Cells(3, LoopColumn).Value
'MsgBox SearchFGIPN & " " & LastColumn & " " & LastColumnName
'Find column # of SearchFGIPN in SuperBOM sheer
If (SearchFGIPN <> LastColumnName) Then
FoundColumn = Application.WorksheetFunction.Match(SearchFGIPN, Worksheets("SUPERBOM").Rows(1), 0)
End If
Display More
Code
'Enter lookup BOM qty into cell * SO Qty
Cells(LoopRow, LoopColumn).Value = ActiveWorkbook.Worksheets("SUPERBOM").Cells(FoundRow, FoundColumn).Value * Cells(2, LoopColumn).Value
For this set of code, and get the value from another sheet using the match function and calculated the values i wanted by multiplying the values to the row 2 of each column. is there anyways that allow me to show the equations on the cell when i select the cell using the mouse thank you so much, the photo of my main sheet is bellow thank you.