VBA to copy/paste but requires window start & stop row selection

[TLH]

Need a vba that opens a new sheet, same workbook, requires the operator to enter the starting row/column cell of data, ending row/column cell of data to be copied to the new worksheet and place the new worksheet at the end of all worksheets, then require a sheet name to entered.

 

[Saurabhj]

Hi, Do you need VBA for below operations:

1. In the existing Workbook, specify the start range (A1) and End Range (H200).
2. Create a new worksheet in the same workbook at the end of all sheets.
3. Copy the specified data (start to end range) in the new worksheet.