VBA Formula

Closed
Report
Posts
3
Registration date
Tuesday May 31, 2016
Status
Member
Last seen
June 1, 2016
-
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