I want to create a macro that when date is inserted into certain cell, have the whole line moved to a new worksheet, and re move from original sheet.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
ffice
ffice" /><o
></o
>
<o
> </o
>
attempted to create the formula, but insufficient excel knowledge,<o
></o
>
<o
> </o
>
<o
> </o
>
needs whole line moved to new worksheet if column "i" contains<o
></o
>
<o
> </o
>
-------------------------<o
></o
>
needs a macro that will<o
></o
>
1. check the completed date cell for data<o
></o
>
2. IF the data is present, then COPY the data in the row from one sheet to another<o
></o
>
3. THEN delete the data from the original sheet<o
></o
>
4. LOOP through and go to the next cell to check<o
></o
>
5. Variables would have to be used<o
></o
>
<o
> </o
>
<o
>Any guidence would be super appriciated </o
>
<o
>Thank you in advance!
</o
>
<o
attempted to create the formula, but insufficient excel knowledge,<o
<o
<o
needs whole line moved to new worksheet if column "i" contains<o
<o
-------------------------<o
needs a macro that will<o
1. check the completed date cell for data<o
2. IF the data is present, then COPY the data in the row from one sheet to another<o
3. THEN delete the data from the original sheet<o
4. LOOP through and go to the next cell to check<o
5. Variables would have to be used<o
<o
<o
<o