Paste Data into Contiguous (Visible) Cells

T

trev_sk8r

I am trying to paste data from a set of contiguous cells in one sheet
into some cells in anther sheet. I have hidden the columns I do not
want to paste the data so that the selection that I would want to paste
into looks contiguous. I was hoping that Excel would see it that way
also and just paste one cell after another. However, it chooses to
paste to the hidden cells, which is not what I want. Does anyone know
how (without writing a macro) I can paste into cells that are not
contiguous normally, but appear contiguous when some columns are
hidden?

Thanks in advance.

Trevor
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy addition formula of non-consecutive horizontal cells 2
Cell data entering slow! 0
Pasting a cell into bookmarked table from excel vba 1
How to merge 2 + contiguous cells without lossing data? 2
MACRO - Copy several non contiguous cells. ~90% there... 0
Visible cells 1
Excel does not accept text format! 0
Copy columns by Header and select all data (non-contiguous) from those columns 8

Top