Use vlookup of index match to retrieve values in multiple sheets

[Nando1988]

I need to make a macro, that looks for a value from data sheet, in all the sheets in the workbook, and if it's is found, it will add that value found with the next, and after all the values are found, a summary sheet will be made with the value that was searched for and the accumulated value.

 

[onlyadrafter]

Hello,

Have made two assumptions:

Sheet1 is where your value from data sheet is (in Cell A1).
All the other sheets are just data entries, i.e. no formula

Sub FIND_VALUES_AND_ADD()
    MY_VALUE = Sheets("Sheet1").Range("A1").Value
        For MY_SHEETS = 2 To ActiveWorkbook.Sheets.Count
            Sheets(MY_SHEETS).Select
            Cells.SpecialCells(xlCellTypeConstants, 23).Select
            For Each MY_CELL In Selection
                If MY_CELL.Value = MY_VALUE Then
                    MY_SUM = MY_SUM + MY_VALUE
                    End If
            Next MY_CELL
        Next MY_SHEETS
        Sheets("Sheet1").Range("b1").Value = "Total Value is " & MY_SUM
        Sheets("Sheet1").Select
End Sub

is this at all close to your requirement?

 

[Nando1988]

This is what I needed, thanks.