erikjanneman
New Member
- Joined
- Jun 9, 2015
- Messages
- 1
Hi,
I have a question about creating a macro.
I have a document in which I keep my leads. The status of a lead can change. I have a dropdown menu with several options going from 0% up to 100% (meaning signed in) and also a option when the lead is not viable.
What I would like to do is, whenever I select the option 100% from the dropdown menu, to move this complete row to a second sheet in the same file. I also do not want to leave a blank row, I would like the rows to re-arrange themselves so there is no blank row.
The same I would like to happen with 'not viable' leads. Move to a different spot on a separate sheet in the same file.
I think this is quite complex and have no idea where to start. Is it even possible?
I hope someone can help me.
Thanks in advance.
Regards,
Erik
I have a question about creating a macro.
I have a document in which I keep my leads. The status of a lead can change. I have a dropdown menu with several options going from 0% up to 100% (meaning signed in) and also a option when the lead is not viable.
What I would like to do is, whenever I select the option 100% from the dropdown menu, to move this complete row to a second sheet in the same file. I also do not want to leave a blank row, I would like the rows to re-arrange themselves so there is no blank row.
The same I would like to happen with 'not viable' leads. Move to a different spot on a separate sheet in the same file.
I think this is quite complex and have no idea where to start. Is it even possible?
I hope someone can help me.
Thanks in advance.
Regards,
Erik
