Hi all,
I've trying to look for a code that basically copy 2 of my sheets to a new workbook and save it to a filename of my choice. I've tried a sample file that was posted in this forum.
However when i do a filter and try to copy it, it end up copying everything ignoring the filtered. I think the code syntax may revolve around the special cell visible thingy. Maybe i could be wrong.
Btw, I've post a sample file to better describe what i want.
Anyone can help thanks in advance. cheers.