I have a workbook that has a running master list of job candidates. In the master list there are columns such as candidate, recruiter, location, and other general information. One of the columns contains status information such as "offer extended", "offer accepted", "reneged", "declined", etc that can be selected from a drop down box.
There are other tabs in this workbook with titles "Hired", "Declined", and other titles corresponding to the selections in the drop box above (with identical columns).
What I would like to do is have a macro put in place that, for example, when "Offer Accepted" is chosen from the drop down box in the master list, would automatically take all that specific candidates information (in the row) and place it in the "Hired" workbook and remove the information from the master list.
There will only be certain selections from the Drop-down box that will trigger a cut and paste into lists on other tabs as well.
Master List Example:
[TABLE="width: 500"]
<tbody>[TR]
[TD]Candidate[/TD]
[TD]Recruiter[/TD]
[TD]Location[/TD]
[TD]Status (Choose from Drop-Box)[/TD]
[TD]Start Date[/TD]
[/TR]
[TR]
[TD]Jim
[/TD]
[TD]Steve[/TD]
[TD]NY[/TD]
[TD]Offer Accepted[/TD]
[TD]1/1/17[/TD]
[/TR]
[TR]
[TD]Karen[/TD]
[TD]John[/TD]
[TD]NY[/TD]
[TD]Offer Extended[/TD]
[TD]1/3/17[/TD]
[/TR]
[TR]
[TD]Bill[/TD]
[TD]Steve[/TD]
[TD]SF[/TD]
[TD]Reneged[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Tanya[/TD]
[TD]Steve[/TD]
[TD]LA[/TD]
[TD]Declined[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
I am new to VBA but willing to follow VBA instructions if needed.
There are other tabs in this workbook with titles "Hired", "Declined", and other titles corresponding to the selections in the drop box above (with identical columns).
What I would like to do is have a macro put in place that, for example, when "Offer Accepted" is chosen from the drop down box in the master list, would automatically take all that specific candidates information (in the row) and place it in the "Hired" workbook and remove the information from the master list.
There will only be certain selections from the Drop-down box that will trigger a cut and paste into lists on other tabs as well.
Master List Example:
[TABLE="width: 500"]
<tbody>[TR]
[TD]Candidate[/TD]
[TD]Recruiter[/TD]
[TD]Location[/TD]
[TD]Status (Choose from Drop-Box)[/TD]
[TD]Start Date[/TD]
[/TR]
[TR]
[TD]Jim
[/TD]
[TD]Steve[/TD]
[TD]NY[/TD]
[TD]Offer Accepted[/TD]
[TD]1/1/17[/TD]
[/TR]
[TR]
[TD]Karen[/TD]
[TD]John[/TD]
[TD]NY[/TD]
[TD]Offer Extended[/TD]
[TD]1/3/17[/TD]
[/TR]
[TR]
[TD]Bill[/TD]
[TD]Steve[/TD]
[TD]SF[/TD]
[TD]Reneged[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Tanya[/TD]
[TD]Steve[/TD]
[TD]LA[/TD]
[TD]Declined[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
I am new to VBA but willing to follow VBA instructions if needed.