I probably won't explain this very well but here goes. Lets say I've got four columns of numbers, say A1-A5, B1-B5, C1-C5, D1-D5. Want I want is for all these cells to be in row one. So, I select cells A2-A5, B2-B5, C2-C5, D2-D5 and drag to cell E1, hoping that the copied cells will fill in row one, but they don't. Is there a way to do that? Otherwise I have to keep copying and pasting until all the cells are in the row. I know a macro could possibly do this, but the ranges will be different each time.
Thanks for your help.
Sorry, almost deleted this post while trying to clean up the spam being left. I am not an excel expert but I know a site that might be able to help you out some if no one here can.
Near the bottom of this link it has cell referencing stuff.