Swift Salmon
New Member
- Joined
- Jun 1, 2015
- Messages
- 2
Hi all,
So I need to create a formula/macro to automatically move a row from one worksheet to the other. The gist of it is that once you change a status from "active" to "closed" (which you manually write in) the row that is now "closed" will move from Worksheet 1 to Worksheet 2. Is this even possible to do? I don't have much experience with macros or changing around the code in the workbook so detail is much appreciated. In reference to the actual information, there will be headers across the top that read "status", "cost", "department" and so on. Any help would be awesome and thank you very much.
So I need to create a formula/macro to automatically move a row from one worksheet to the other. The gist of it is that once you change a status from "active" to "closed" (which you manually write in) the row that is now "closed" will move from Worksheet 1 to Worksheet 2. Is this even possible to do? I don't have much experience with macros or changing around the code in the workbook so detail is much appreciated. In reference to the actual information, there will be headers across the top that read "status", "cost", "department" and so on. Any help would be awesome and thank you very much.