After the Form is done

[Asevens]

So I have my userform set up and it transposes data the way I want it to. Now, I am trying to figure out how to make the rest of my data show up and THEN copy the worksheet within the workbook to a sequentially numbered worksheet which is then displayed for manual editing and printing.
*Edit* When copying the worksheet I need to only copy values not formulas AND i need to find a way to not carry over the userform initialise button on the actual worksheet.

I also need help with creating a second macro that will be activated based off check and option buttons which would print off the corresponding documents.

I may be asking too much but I am swimming in the deep end of VBA and I still have my floaties on.

 

[Logit]

.
To create the new sheet and copy data to it, paste this macro into a Routine Module:

Option Explicit


Sub cpypste2()
On Error Resume Next
Application.ScreenUpdating = False
    Sheets("Sheet1").Range("A1:F35").Copy                           '<-- adjust copy range here
    Sheets.Add After:=Sheets(Sheets.Count)                          '<-- creates new sheet
    Range("A1:F35").Value = Sheets("Sheet1").Range("A1:F35").Value
    Selection.Columns.AutoFit
    Selection.Rows.AutoFit
    Columns("A").ColumnWidth = 9.86
    
    Sheets(Sheets.Count).Name = Sheets(Sheets.Count) + 1
    
    Sheets(Sheets.Count).Select
    Application.CutCopyMode = False
Application.ScreenUpdating = True
End Sub

Need more info. regarding the printing / checkboxes, etc.