PDA

View Full Version : Macro: Move Cells where QTY is in upper percentile



pdx_2188
03-30-2011, 06:49 PM
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
03-30-2011, 07:36 PM
the attached document does not have any macro in it.

pdx_2188
03-30-2011, 07:48 PM
Here you are. Sorry I must have saved the wrong one.