Automatically Copy Row Based on Cell Value to New Tab

[marleymstuhmcke]

Hi all,

I am hoping someone can help me. I am not good with using VBA, so hoping someone could help me with a formula.
I have a spreadsheet that I manually input data in. Columns G, I and J have a formula in them that changes value based on the cell beside it (which I input the data beside it). So, if cell F3 has 5 in it, cell G4 will go to 0 and turn red.

What I am trying to achieve is having all the red cells with the value of 0, automatically copy into the next tab "Exceeded", but I want the whole row to copy not just the one cell. So, if G3 is red and value is 0, I want the whole of row 4 to copy into the next tab "Exceeded." But I also want that row to remain in the original tab as well "Current". This formula will need to be for the whole worksheet as data is inputted daily. So columns A through to L.

I have added a pic of what my spreadsheet looks like. I hope someone can help

 

[Fluff]

Duplicate to: Automatically Move Row to Another Sheet Based On Cell Value

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.