Transfer data to specific range based on condition

Dear Excel Experts,

I need to develop a Macro that performs the following when the bottom "Submit" is pressed:
If In Book 1, Cell "C8" = "Q1" then the Macro will select Cells(B7, C7, D7, E7, E69, F69, G69, B8) and paste the result to Book2 in a range between A2:F19
If in Book 1 Cell "C8" = "Q2" then the Macro will select Cells(B7, C7, D7, E7, E69, F69, G69) and paste the result to Book2 in a range between A20: F42
If in Book 1 Cell "C8" = "Q3" then the Macro will select Cells(B7, C7, D7, E7, E69, F69, G69) and paste the result to Book2 in a range between A43: F62
If in Book 1 Cell "C8" = "Q4" then the Macro will select Cells(B7, C7, D7, E7, E69, F69, G69) and paste the result to Book2 in a range between A62: F82

I look forward t receiving your thoughts

Kind Regards

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem. Once you have done this please send me a PM and I will remove this request.

To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

Do you have a sample file or files that you can upload?

To Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.

Will the ranges in Book 2 always be the same?