|re: is there a way for me to run the macro on an active workbook and for it to just take the end of one sheet and move it to another.|
As written, the code I offered does not care about sheet names since it refers to the sheets by number (1 & 2) in the order that the sheet tabs appear
Sheets(1) is the first sheet, Sheets(2) is the second.
If Sheet1 was named Parts, you could use Sheets(1) or Sheets("Parts") to refer to that sheet. The advantage of using sheet names is that you can rearrange the order of the tabs without impacting the results of the code. You can't do that if you use sheet numbers.
By the way, you can also "calculate" the sheet reference in various ways.
- Sheets(Sheets.Count) will refer to the last sheet.
- Sheets(Sheets.Count -1) will refer to the second to last sheet.
- Sheets(Sheets(1).Range("A1").Value will refer to the sheet whose name is stored in Sheets1!A1
myNum = 1
myShtName = "Sheet" & myNum + 2
will refer to Sheet3
I could go on all day, but I think you get the picture.