I am ready
I started over but it still doesn't copy all columns - it misses the names and the columns after that.
Also it is better to copy all the cells - not only visible ones. And if it can copy only the data from these specific sheets - Crawler, Various, MandM, Fragrance, 5£. Because I have other sheets with not formatted and unnecessary data.


Thanks a lot for your help.

Attached Files

???? SUMMARY.xlsm (56.2 KB, 7 views)

Hi,

I'll look at this tomorrow.

Hi,

See if this works for you.

Attached Files

attachment-1.xlsm (56.0 KB, 7 views)

Hello!
Yes it copies the names and the hidden columns data
It still copies the data from all other sheets too

HI

Sorry I miss read your information. I'll make the necessary correction in the next couple days.

Thanks very much for your help!

HI,

See if this works.

Attached Files

attachment-1-2.xlsm (56.6 KB, 20 views)

It works! Thank you!

Hi,

I just teased my copy and it does populate the "Summary" sheet. Did you change any worksheet names?
If so you must change the code that has the name that you changed.

Just edited my last post. The working sheet names are the same. Only it matters if the other sheets are before or after the working ones.

Hi,

Was gone and did not log out. In the code module for select case you will see "Else". In it you will see "Exit Sub" remove it and I think it should work.

Hi,
I finally added it to my file successfully!
I had to use the export function. I am totally novice at all of this.
Thank you again!