How to select files through list by vlookup or VBA

0

I need to parse multiple files in .XLSX that are in several folders and generate the data graphs, all .xlsx files have the same amount of rows and columns in a spreadsheet with a specific name.

I've created another file so that I can copy and paste the data and the graphics are generated automatically. I wanted to select a file through a list and the data would be read by my graphics file.

I have tried vlookup but I can not make the folder choice where the files are.

I was able to modify a VBA, which is described below, but it does not modify the formula in cells.

Sub FindReplaceAll_CountReplacements()
    'PURPOSE: Find & Replace text/values throughout entire workbook, notify user of how many cells were affected
    'SOURCE: www.TheSpreadsheetGuru.com

    Dim sht As Worksheet
    Dim fnd As Variant
    Dim rplc As Variant
    Dim ReplaceCount As Long


    fnd = Range("F3").Text
    rplc = Range("F2").Text

    For Each sht In ActiveWorkbook.Worksheets

        ReplaceCount = ReplaceCount + Application.WorksheetFunction.CountIf(sht.Cells, "*" & fnd & "*")

        sht.Cells.Replace what:=fnd, Replacement:=rplc, _
                          LookAt:=xlPart, SearchOrder:=xlByRows, MatchCase:=False, _
                          SearchFormat:=False, ReplaceFormat:=False

    Next sht

    MsgBox "I have completed my search and made replacements in " & ReplaceCount & " cell(s)."

End Sub
    
asked by anonymous 21.12.2018 / 15:52

0 answers