Hi and thanks for viewing this post. I am new to the site and have little experience with macros and VBA. I was hoping someone could help me here.

1. User enters data into A3 through R3
2. User hits the button
3. Code looks for data entered in rows starting from A3 and stops when a row has no more data.
4. Code copies data from those rows
5. Code opens another document located in a shared folder
6. Code looks for next available empty row
7. Code pastes copied data onto that space
8. Save target workbook
9. Close target workbook
10. Save 1st workbook
11. Close 1st workbook