Here's what I got
How do I make it use the input number to copy and paste it that many timesSub HowmanyGDAs() Dim QtyEntry As Integer Dim Msg As String Msg = "How Many GDAs did you do?" QtyEntry = InputBox(Msg) ActiveSheet.Range("A7:H20").Select Selection.Copy Range("A22:B22").Select ActiveSheet.Paste End Sub
also would like the input box to open when workbook starts, or at the very least with hotkeys.
I would like the Info from range "A7:H20" to be pasted below H20 with H21 being blank and this to be repeated based on the number input into the inputbox
Thanks!
Bookmarks