Dear Marcus, Great video! Some suggestions: 1. You may want to automate the process of copying column headings too in sh(2), in stead of doing it manually - so, Offset fx may be deleted altogether; 2. Add CutCopyMode = false and CutCopyMode = True at appropriate places in the code; 3. Add ScreenUpdating = false and ScreenUpdating = True at appropriate places in the code; 4. Also do a video on Advance Filter. Thanks & stay safe.
Thanks for your comments. 1. I always set the other sheet up with the headers, it's my preference. Has the additional advantage of showing peeps how Offset works. 2. Why would you add CutCopyMode = False - by doing any further code after the Copy - the copy markers disappear. An additional line - zero value in my example. :)
@@sandeepkothari5000 OK cool - let me regale you. What is the purpose of the CutCopyMode = false......... to turn off the copy mode that draws a dotted square around cells. In code if you copy and paste from one place to another, no square exists. [A1].Copy [B1] 'Produces no dotted square Try it. If you are pasting Special Values the square is there - however if you do anything else within VBA, the dotted square disappears and is extinguished from memory. So in conclusion the only time you would use CutCopyMode = false is when you are pasting special and it is the last line of code .... hence the copy square is deleted. Not remotely needed in my code as I am not pasting special - it is direct so no dotted square ever happens. It is a line of code that serves no purpose. Does that make sense?
@@sandeepkothari5000 Awesome man. Feel free to write to me if you have any questions about Excel or VBA. My website is an absolute monster of a resource if you ever swing by! Take it easy. :)