VBA Formula

nicole4763 Posts 3 Registration date Tuesday May 31, 2016 Status Member Last seen June 1, 2016 - Jun 1, 2016 at 10:44 AM
I need to create a macro that allows me to copy and paste a set of formulas/values down a certain number of times. For example, if I had the following 6 name values in cells B2:D3 and wanted to copy that specific block down to B5:D6, B8:D9 etc. all the way down to a specific row such as row 50, what VBA formula can I use?

Aaron Jessica Joseph
Samuel Taylor Stephanie