Copying Information across Pages

[Carl1993]

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

[opus]

I did all that for you exemt the part where you want to move up items that are in rows below a actual copied row.
Didn't that work? If not, what is the problem? What are you using as input in the %-cells, are the formatted as %-value (which I assumed!)?

[Carl1993]

I tried what you sent me, but what seems to be the problem is regardless of the percentage it copies the row into Sheet3 and the information always gets posted in the same row, so if I change 2 percentages it pastes over the first one I changed. And if it is between 50 and 100% it goes to sheet3 I only want 100% in Sheet3 and 50-99% to go to Sheet2

[opus]

please post the .xls file you use!