I have one Workbook.
First sheet is named "Main Sheet", second sheet is named "Summary", all sheets after have specific names (different Themes).
On "Main Sheet" user will be inputting data in categories eg. in 5 columns ("A:E"). All the other sheets will have same columns.
On "Main Sheet" I'm working on a button that will loop through column eg. "C" (Themes), match it with sheet name, and copy the row from "Main Sheet" and paste it after the last input in the sheet with the same name (Themes).
At the same time after the user will finish the input in the "Main Sheet", button should copy/paste all the inputs to "Summary" sheet (paste after the last input in "Summary" sheet) and delete inputs in "Main Sheet".
I have attached workbook for better understanding.
Thank you.
Bookmarks