Hello all,

I'm having a little problem, I am trying to make a code so that, I can copy and paste entire rows. I want to be able to do this via making the rows being copied based on what the value of the percentage in the row. If it is above 50% I would like it to copy that row and move it to sheet2, if it is 100% I would like it to move to Sheet3, so inbetween 50% and 99% are sheet2, anything under 50% is sheet1, and 100% alone is sheet3. I would like this to be able to automatically move as I change the values of the percentages.
The thing is, as well. I would like all of the information under the row moved, to move up so there are no blank rows, and I would like it to move to a spare space in the appropriate sheet without constantly pasting the information into the same row deleting the previously moved information

If you simply just enter test 1 into your A column and a percentage below 50% in Sheet1, you can make the code exactly how I would like it.

Thanks for anyone who can help