Hello,
I have an existing Macro that takes information from one worksheet input form and copies it onto two other worksheets. Below
Sub Florida_Student_Services()
CopyToPage "Data"
CopyToPage "Fin. Affairs"
End Sub
Function CopyToPage(ws_output As String)
next_row = Sheets(ws_output).Range("A" & Rows.Count).End(xlUp).Offset(1).Row
Sheets(ws_output).Cells(next_row, 1).Value = Range("campus").Value
Sheets(ws_output).Cells(next_row, 2).Value = Range("date_paid").Value
Sheets(ws_output).Cells(next_row, 3).Value = Range("type").Value
Sheets(ws_output).Cells(next_row, 4).Value = Range("amount").Value
Sheets(ws_output).Cells(next_row, 5).Value = Range("payee").Value
Sheets(ws_output).Cells(next_row, 6).Value = Range("payment_for").Value
Sheets(ws_output).Cells(next_row, 7).Value = Range("GL_Number").Value
Sheets(ws_output).Cells(next_row, 8).Value = Range("Notes").Value
MsgBox ("Submitted")
End Function
What I'm wanting to do, is just add a "print this page" within the existing function.
How do I do that?
I have added "example workbook" incase, I'm having employees enter data on the "Entry" tab. From there the information is sent to "data" tab and a hidden tab "fin affairs". I had a "print" button on the entry tab but it was not being used correctly, so to save everyone a headache I wanted to combine the print function in with the submit function button.