Copy with macro columns between 2 different workbooks

Hi I have below long code which are nearly working. Its just a recorded code.
It copy selected columns between workbooks. I need help to do following.

Make the code much shorter.
Correct the code so I don't get problem with shape and range, which I sometime does, and get and error.
Both workbooks will be open on but will be good to be able to name the sheets with a input box, if its possible.


Please have a look and see if you can make some good changes.
Thanks in advance
Sincerely Abjac

Please Login or Register  to view this content.

Hi No answers here but I made below code its a little shorter and it have the input boxes. Its not perfect but working . So I will mark this thread as solved.

Abjac

Please Login or Register  to view this content.

Hi No answers here but I made below code its a little shorter and it have the input boxes. Its not perfect but working . So I will mark this thread as solved.

Abjac

Please Login or Register  to view this content.