Cstewart29
New Member
- Joined
- Feb 8, 2023
- Messages
- 4
- Office Version
- 365
- Platform
- Windows
Hi,
So I have been trying to build a spreadsheet that requires moving rows of information from the main "Caseload" sheet into any one of 12 sheets (January-December) in the same document, also deleting the information from the "caseload" sheet.
The idea would be to highlight the row and click a button that will move the row. I have decided to add to column R a drop down list 1-12 to use to determine which month to transfer to.
Now while I have created a button to move a row to ONE other sheet before, this task has proven too much so far so I was hoping to ask some smart person for help?
Thanks to anyone who can help. Let me know if there is anything I haven't made clear!
So I have been trying to build a spreadsheet that requires moving rows of information from the main "Caseload" sheet into any one of 12 sheets (January-December) in the same document, also deleting the information from the "caseload" sheet.
The idea would be to highlight the row and click a button that will move the row. I have decided to add to column R a drop down list 1-12 to use to determine which month to transfer to.
Now while I have created a button to move a row to ONE other sheet before, this task has proven too much so far so I was hoping to ask some smart person for help?
Thanks to anyone who can help. Let me know if there is anything I haven't made clear!