Hi all,
This is an extension of my original thread, however a different approach hence totally a new issue & a question .
I was helped by Greg M for the Original thread and its really a great solution and is working fine with me.
Thread is located at the following:
As for my learning - Part TWO, I have thought of a different approach ( may not be the correct one). All the code below is fine. I have highlighted in red where I want to amend this code with your help.
I am trying to achieve is shorten code to incorporate copy data to another workbook as well.
I have tried many combinations, but can't get it work.
Hope some one can help me in my learning.
Apology for such a long thread.
Many thanks
Kind Regards
Bookmarks