Move entire row to new sheet if condition is true in a specific column

**mic1978** · 03-12-2013, 10:11 PM

I have an excel sheet (see attached) that is intendend for scheduleing use. I will like to export the entire row in the master schedule sheet to a new sheet (move sheet) if column D (QC required) is yes. If the row is moved I will like to append to the existing row if there were any existing data.
I will also like if column D can be a check mark instead of typing yes.

NOTE. The problem that I am having with the check mark is when I insert a new row it does not insert the check mark.

I will appreciate any help with this.

**arlu1201** · 03-13-2013, 08:18 AM

To insert a check mark, you need to format the whole column (minus the header rows) using the webdings font. When you type a in the cell, the tick mark will appear.

Can you explain some more about this - If the row is moved I will like to append to the existing row if there were any existing data.

**mic1978** · 03-13-2013, 02:04 PM

Thanks you for the prompt response. The check mark does not help me. I meant to say check box.

Also with the append to the existing row.
I meant to add to the table in the QC sheet every time there a new row in the master schedule column D is true.

**arlu1201** · 03-13-2013, 02:42 PM

I meant to add to the table in the QC sheet every time there a new row in the master schedule column D is true.

You mean add to the next available row right?

**mic1978** · 03-13-2013, 02:52 PM

arlu1201 yes.

**arlu1201** · 03-14-2013, 07:34 AM

Do you want the movement of data between the sheets to happen instantly?

For e.g. if the checkbox does not work, you can have a dropdown in that column and have the user select "YES" from the dropdown. You can then have that row moved / copied to the Move sheet as soon as the dropdown is selected.

Or

You can select the values in the dropdown for each row and then click on a button to have the data copied / moved.

Also, do you want the data to be copied and pasted or cut-pasted?

**mic1978** · 03-14-2013, 08:29 AM

Do you want the movement of data between the sheets to happen instantly?
Yes. Or it can happen after the sheet is save and close.

I would prefer the first option of if the checkbox does not work then the user can select from a dropdown Yes or No.

I also would want the data to be copied.