Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Looking and regrouping informations accros sheets

Hakimipous
10 - Fireball

Hello,

 

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

1 REPLY 1
Hakimipous
10 - Fireball

Solved the issue thanks to the awesome  Crew Macro package

 

http://www.chaosreignswithin.com/p/macros.html hope it may helps others in the need

Labels