Copying cells to another workbook/worksheet

[MoeB]

I'm new to this forum and have read some great stuff already. Thanks to the experts who participate. I'm a noob when it comes to macros and VBA and I think my question will entail either or both.

My question is almost exactly that of this thread, but with an additional question (and I didn't want to hijack that thread.

I want to be able to copy a range of cells (variable rows, fixed columns as in the previous thread) either to a new worksheet or to a new workbook. Either would work, though I would prefer to do the latter. I'd also like to be able to pull the same selected data from two workbooks and combine them into one, simply copying one after (below) the other. What I'm after is the preservation of not only the data, but the formatting, so it looks exactly like the worksheet it is being copied from.

Does this require VBA/macros? (in which case is the code in the previous thread my best bet?) or is there a function that will preserve formatting (even for a single cell)?

Would the syntax change if the columns to be copied were not contiguous? (e.g. instead of copying A:G, I needed A:B, D:E, G)

Thanks in advance.