Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Looking and regrouping informations accros sheets




I'm working with a lot of excel files currently, and I have to link information across different sheets



For example, in my 1st excel file I have a sheet containing a name, and in an another sheet I have the name with an ID  number (the rest of the sheets are not relevant )


So the I would like to create a macro that could regroup those information together


Like, in Sheet 1 I have Mat + Some useful info, and In Sheet 2 I have Mat 0098. Rest of the sheets can be ignored.

Result should be a table With the info from both sheets 


Could that be done? 

Thanks !


A Macro beginner


Solved the issue thanks to the awesome  Crew Macro package hope it may helps others in the need