• Welcome to Free PC Help, a free PC Help forum to get help with your computer problems.

    Free PC Help is a community that offers free computer help and support for all users, all ages, worldwide.

    In order to start asking questions or contribute on someone else's post you will first need to register. Don't worry - it's quick and easy and once you have registered you will have instant access to the entire forum.

    If you do decide to join the forums you will not have the option to send Private Messages [ PMs ] or add a Signature until you have made 5 posts or more. This is an attempt to try to stop Spammers using the PM system or adding links to their Signature.

Move a row to another sheet in excel based on column value

elfriniel

Free PC Help Contributor
Joined
Jan 21, 2011
Messages
8
PC Experience
Beginner
#1
Hi,

I hope someone can help. I have tried to find code for this, but all the ones I find are wrong.

I have a workbook containing the sheets "Main" and "Completed".

What I would like to happen is when I put a yes in Column G in Main, the whole row gets moved to the sheet Completed.

If you can help, please give instructions suitable to a complete novice, and I really have no clue what I am doing.

Just to add I am using Windows 7 and Excel 2013

Thanks