Picking the correct sheet based on client name

Karthick_sankar

Dear All,

Each client send their excel input files with different sheet names, how to combine all the client input files into one? (lets assume the columns are in the standard format) Please advise if you have any solution to combine if the format is not standard and the starting row is different.

Thanks in advance.

Karthick

Input

Accepted answers

hi @Karthick_sankar

You can also build a macro to read the differents sheets and the advantage is you can customize the things that you need.

I attached an example

LeerArchivos_xls.yxmc

All comments

patrick_mcauliffe

Have you tried the Wildcard XLSX macro from Crew?

http://downloads.chaosreignswithin.com/Macros.zip

hi @Karthick_sankar

You can also build a macro to read the differents sheets and the advantage is you can customize the things that you need.

I attached an example

LeerArchivos_xls.yxmc

Karthick_sankar

Thanks for sharing 🙂

Quick Links

Tags

This months top contributors

AkimasaKajitani 389

michael_weaver 335

Hollingsworth 335