Is there a way to copy/paste cells in a specific order? What I mean is, say I click on cell A1. Then I hold down ctrl and click on A3, A5, A8 and A9 to add those cells to my selection, then I copy them. What I want is to be able to paste those cells into column B, keeping the row numbers the same: B1, B3, B5, B8 and B9 would take the contents of the cells I copied from column A.

I've toyed around numerous times with the "paste special" menu, but every time I paste, the cells end up in a consecutive order: B1, B2, B3, B4, and B5. It'd make my payroll-related duties about 1000 times less redundant if I could just paste cells in the exact order that I copied them. A plea from someone who is Excel-impaired: HALP!

...Pretty please.