Moving A Cell From one sheet to another based on 'Status' i.e. Column Cell

[warri0r]

AB33,

Your code does move the Row from one sheet to the other. However, when it inserts the copied Row on the other sheet, it doesn't shift the rests of the rows on the sheet down. I may be doing something wrong but I just don't see the rows move down.

So to clarify a bit more, it would be very helpful if it shifts the rows down and than it inserts the copied row.

Thank you for your help AB33.

Please Login or Register  to view this content.

I'm looking for a bit more help with the above code. The code above moves an entire 'Row' from one spreadsheet to the other spreadsheet according to a cell value. However, it does not shift the other rows down from the second sheet before inserting the Copied 'Row'. It overrides 'Row 4' from the second sheet.

I've attached an example.

[HaHoBe]

Hi, warri0r,

why do you start a new thread instead of staying in the old one? Might conflict with Rule #5. And a full quote doesn´t comply with Rule #12.

Ciao,
Holger

[warri0r]

How can I go about delete this post?