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
Any ideas?
Thanks,
Jeff