VBA or Excel formula to move rows across different sheets

[Pepper1990]

new to VBA and basic knowledge of excel I'm trying to find a formula or VBA to move rows with a selected dropdown label to respective sheet from a master membership tracker

 

[Kaper]

At this general level - the answer is: you shall use VBA to move rows. If you want to have a real copy, VBA is needed too. If you want just display specific content (from the poit of view of a user is: showing a copy) formulas shall do the job.

Have a look on XL2BB - Excel Range to BBCode how to show us the details of your problem.

 

[Pepper1990]

At this general level - the answer is: you shall use VBA to move rows. If you want to have a real copy, VBA is needed too. If you want just display specific content (from the poit of view of a user is: showing a copy) formulas shall do the job.

Have a look on XL2BB - Excel Range to BBCode how to show us the details of your problem.

Thanks for the reply, Id prefer a VBA cause I need a "Real copy" what i aim to do when "FULL" is selected from the dropdown box I would like for excel to automatically cut and past the whole row from Sheet "Master List" to "Full Members" and vice versa with the "Potential Members" Thanks