Help Extract from a Excle File Multiple Sheets with Specific Column Range

[Lorenzo LM]

Dear all,

I need your help

I have a File, inside this file there are n sheets all formatted in same way but each sheet has different name.

I need to extract from the file all this sheet with the same specific range of column.

For example:
File RESULT
SHEETS 1 2 3 4 5
Column range C to D and Y to Z

I need to create 5 new file, each of them called with the same name of the sheets so 1 2 3 4 5 and on each of them I must find the data from the range column mentioned above...


now I am using this macro, but it create just the files based on the n sheets of master file

Please Login or Register  to view this content.

and I want to combine it with this macro that copy specific columns for each n sheets in the n files created

Please Login or Register  to view this content.

I wish I was clear, I need to combine them please...


also my reports for each sheets have merged cells, I need also to remove th emerge in order to copy the columns.


thanks a lot

lorenzo

[JLGWhiz]

I am not sure about the sheet and file names, but the ccode is based on what is in the OP, so give it a try.

Please Login or Register  to view this content.

[Lorenzo LM]

first of all thanks for your answer, is not working...

as I can see in your script is the for is until 5, but usually I don't know how many sheet I have, can be 5 or 10 or 20...

the two scripts I have are working if are isolated, but I want to merge them...and include a script that remove all the merge cell for each sheet before exporting them...

thanks

[AliGW]

Lorenzo - welcome to the forum!

Please note that our rules require you to enclose your code in code tags. I will do it for you this time, but you must do it yourself in future. Thanks!

[Lorenzo LM]

Hello,

thanks, sorry for it, I will do for future posts...

thanks

[AliGW]

Thank you.

[Kaper]

One of possibilities:

Please Login or Register  to view this content.

[JLGWhiz]

I am trying to do this so that your original file stays intact. I think this might produce what you want but leave the cells merged in the original file.

Please Login or Register  to view this content.