|re: "Please forgive me but most of the VBA macros that I produce are through the recording option that is available."|
I've never seen the recorder produce this type of code:
nxtRow = Sheets("SCARD").Range("R" & Rows.Count).End(xlUp).Row + 1
Destination:=Sheets("SCARD").Range("R" & nxtRow)
I don't have any specific sites to recommend. I learned to write code by hanging out in forums, asking questions and reading questions and answers from other posters. Unfortunately, as much as I like this site, there aren't too many people offering macros, so you won't get much variety in techniques.
I would subscribe to other Excel related forums and drop in as often as time allows to review what's posted.
In the meantime, read this How-To for some tips on debugging VBA code, both macros that you have written and ones that you find on the web. I learned a lot about writing macros by "debugging" code that I found on the web. I wrote this tutorial as means to share some simple debugging tips.
Above all, keep in mind that the recording feature typically results in very bloated code that is hard to follow. I still record some things, but I always clean it up afterwards.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.