Copy range of cells and paste them multiple times

[Closed]
Report
Posts
1
Registration date
Monday August 15, 2016
Status
Member
Last seen
August 15, 2016
-
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?

Thanks,