Sorry for the confusing title...
I have a workbook that currently has 5 sheets.
Sheet 1 is a summary sheet
Sheet 2, 3 & 5 are hidden (for other purposes)
Sheet 4 is a data sheet
Here is what I am trying to accomplish, and please keep in mind I am not new to VBA, but I am hardly an Expert and this is something I have never tried before.
I am trying to create a macro (started by pushing a button on Sheet1) that will do the following:
Copy Sheet 2 (the whole sheet)
Create a new Sheet before Sheet 5 and name it based off of Input from a Input Box
Paste the copied data from Sheet 2 into this newly created sheet.
This is what I currently have; however, this obviously is not working
I am returning an error on the .Worksheet portion of Excel.WorksheetPlease Login or Register to view this content.
Any help would be appreciated!
Bookmarks