Hey everyone,
Let's say I have a worksheet that has the number 1 to 10 in cells A1:A10. I copy the numbers 1, 2, 9 and 10 and want to paste them into row B while maintaining the spacing in between the selected cells and not have Excel bunch them all together consecutively - how can I do this?
The above is not the actual data I'm working with so it's not a case of single copy-pastes, filling or manual entry. I need to be able to select a disjointed group of cells and when pasted, have them land in the same cell locations but on the new sheet. Basically it's updating a local sheet onto an identical live sheet. The live sheet cannot be copied over or replaced.
This problem has always annoyed me, is there a way around it?
Thanks!
Bookmarks