2 excelreports 29 tabs - needs Vlookup

[Lorenakocheran]

Hi:

I have 2 excel reports each one with 29 tabs. I have to look the new members only so I am thinking to do a Vlookup to only see the new members comparing the 2 reports.  The problem is each report has 29 tabs (sheets) that have to be compared. 

Both reports has the same name on sheets and the variables are the same

Should I do it Sheet by sheet?

Should create a macro?

[griffinwelsh]

In Alteryx you would use the join tool (there is no such thing as a Vlookup here). If your schema is the same across all 29 tabs you can use a dynamic input tool to bring in all your data. Otherwise you should use a batch macro using the sheet name as your control parameter. If you post some sample data we can help you with the build, but hopefully this is enough to get you started.