how to collect another sheet data with in the single file

[ChristopherSuba]

hello everyone, just asking if what action can be done when retrieving another spreadsheet and incorporate it in another excel sheet sample sheet1(main file) sheet2(is another file came from other excel source) in sheet1 there are column needed to be filled up using function vlookup(A3,sheet2!B:G,6,0) and (A3,sheet2!B:H,7,0)   thanks in advance

[ChristopherSuba]

hello again, how to convert into sql string using oledb for this filterin Filter date column, choose blank and all the months that are included in the current tax year (Mar 1 - Current) thanks

[ChristopherSuba]

hello team, just want to ask for help to get next row record after validation.