|re: "I record a macro to Copy 15 lines of data from sheet 2 and paste it to sheet 1"|
re: "I heard about VBA being able to do this much easier and allowing more options. "
If you recorded a macro, then you already have VBA code. That's what a macro is: A series of instructions written in the VBA language. Whether recorded via the macro recorder or written manually by typing the instructions into the VBE (VBA Editor) the result is the same: VBA code.
The main difference is that the recorder usually ends up producing some very ineffcient code since it records all your range selections, mouse scrolls, etc. etc. The code will be bloated and hard to read, but can be cleaned up manually by using the VBE.
re: So I was just throwing it out there to see if I could get something fairly quickly. And then tailoring it to my exact needs.
Why not just tailor what you already "wrote" when you recorded the macro by going into the VBE and editing what the recorder produced?
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.