Copy range of cells and paste them multiple times

bm63081 Posts 1 Registration date Monday August 15, 2016 Status Member Last seen August 15, 2016 - Aug 15, 2016 at 11:44 AM
Hi all,

My VBA / Coding skills are basic and I've been googling to try to find an answer to my question to no avail. I'm trying to copy a range of cells (say from cell B2:AP85) and paste them multiple times in the same sheet below starting on cell B87 based on a value in cell A1. For example, if I enter 5 in cell A1 I would like the data (and all formats, formulas, list, etc.) in cells B2:AP85 pasted below 5 times. Also, I would like the name that is in cell B2 to change from Requests 1 to Request 2, then Request 3, then Request 4, then Request 5 for each time it is copied below. Is this possible?