cancel
Showing results for 
Search instead for 
Did you mean: 
Announcement | Looking to grow your skills and business impact? Join us in Anaheim June 4-7 for Inspire 2018! Sign up by year-end for BIG DISCOUNTS. Register now.

Looking and regrouping informations accros sheets

SOLVED
Hakimipous
Asteroid

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

Highlighted
Hakimipous
Asteroid

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