Dear Excel Experts,

I need to develop a Macro that performs the following when the bottom "Submit" is clicked
1) If Cell "C8" = "Q1" in book1 and sheet1 then the Macro will select Ranges (B7:F7 and E69:G69 and Cell72). The selected cells will be pasted to the next available row in Book2 Sheet Master between Range A2:F21.

2) If Cell "C8" = "Q2" in book1 and sheet1 then the Macro will select Ranges (B7:F7 and E69:G69 and Cell72). The selected cells will be pasted to the next available row in Book2 Sheet Master between Range A22:F41

3) If Cell "C8" = "Q3" in book1 and sheet1 then the Macro will select Ranges (B7:F7 and E69:G69 and Cell72). The selected cells will be pasted to the next available row in Book2 Sheet Master between Range A42:F61

4) If Cell "C8" = "Q4" in book1 and sheet1 then the Macro will select Ranges (B7:F7 and E69:G69 and Cell72). The selected cells will be pasted to the next available row in Book2 Sheet Master between Range A62:F81


I look forward t receiving your thoughts

Kind Regards