Excel 2007 VBA assistance.
Would appreciate any help with this one as it is driving me mad. I can find VBA code to copy and paste rows based on a hard-coded array or specific values. However, I have a user form which allows the selection of any one staff member and any input date and I can't get it working.
Basically I have a huge "Sales" sheet, from which I want to be able to copy and paste entire rows into a "Summary" sheet based on two chosen criteria (Staff name & date of sales) via a userform when the "Submit" commandbutton is clicked.
I then also want to be able to email the "summary" spreadsheet only by clicking another commandbutton, "Email", but I should be okay with this part myself.
Source spreadsheet Name: "Sales"
Column A Staff Name Column B Date of Sales
Data starts row 9
Destination spreadsheet name: "Summary"
CommandButton: brings up user form
Listbox1: list of staff names to select
Textbox1: date to input re sales
"Submit" Commandbutton - want to copy and paste entire rows based on staff name and specific date from "Sales" spreadsheet (from row 9) into "Summary" spreadsheet (from row 9)
As I said, any help would be greatly appreciated!!!