auto clear row and move data up when quantity=0

[ebeeny]

I would like wh1 wh2 wh3 wh4 to clear the line and move the data up when an item quantity is 0. I would like this to happen automaticly. how can i do this?

[mrice]

Try pasting this into the ThisWorkbook tab in the VBA editor.

Please Login or Register  to view this content.

[ebeeny]

thanks that is what i wanted!!!! have a great day!!!!

[ebeeny]

mrice, I need this to only run on certin sheets not the entire file. how can i do this?

[mrice]

The line

Please Login or Register  to view this content.

is used to make sure that the code only runs when the sheet name begins with 'wh'. I understood that this is what you wanted.

[ebeeny]

when i put the code in and try to run my total button on my total page i receive a run time 13 type mismatch. when i hit debug it pull up the code and highlights If Target.Row >= 3 And Target.Column = 2 And Target.Value = 0 Then

thanks for all the help

[mrice]

OK - need to modify slightly as your macro was changing several cells at the same time and as such Target didn't have a single defined value - hence the error.

In the following...

Please Login or Register  to view this content.

... I have added an extra line so that the code only runs if a single cell is changed.

[ebeeny]

Thanks! Works like a champ!!!