Macro: Move Cells where QTY is in upper percentile

[pdx_2188]

I have been given a spreadsheet with a very odd layout. I was told that I need to be able to move the data for the top 5 quantities over to the "Move" worksheet from the SMBDesktop sheet. I have created a macro before where it did something similar, so I copy and pasted this, but i believe the difference is I'm trying to make this happen with an integer instead of a string. If someone could take a look at this and provide some advise that would be greatly appreciated! I do know that the top 5 quantities are over 80, so something like QTY >= 80 move cells First and last to worksheets("move").


Any ideas?

Thanks,
Jeff

[nepotist]

the attached document does not have any macro in it.

[pdx_2188]

Here you are. Sorry I must have saved the wrong one.