I would like to make a command button that when clicked,
will copy the Sheet "Edit" Range A1:B7 and paste it in the Sheet "Summary" Range A1:A7.
Copy Sheet "Edit" Range A9:A19 and paste it in the Sheet "Summary" Range A8:A18
Copy Sheet "Edit" Range B10:B19 and paste it in the Sheet "Summary" Range A20:A29
Copy Sheet "Edit" Range A21:A22 and paste it in the Sheet "Summary" Range A30:A31
so on and so forth.
It is like, it would generate a template from the details I have.
1.JPG
and make it look like this
2.JPG
3.JPG
Thank you
Bookmarks