Paste into Visible Cells Only

Is there a way to paste into visible cells only? I have a spreadsheet with
several columns of data that are not on the spreadsheet I am taking data
from. I have hidden these columns and left only the columns that match the
other spreadsheet. Is there a way to only paste into the cells that are
showing? Thank you in advance for your help.

When you paste, it will paste into a contiguous range, not the visible
cells in the filtered range.

Perhaps you could mark the visible rows, by putting an X in an adjacent
column. Then, sort by the marked column, and paste into the grouped cells.


CR wrote:
> Is there a way to paste into visible cells only? I have a spreadsheet with
> several columns of data that are not on the spreadsheet I am taking data
> from. I have hidden these columns and left only the columns that match the
> other spreadsheet. Is there a way to only paste into the cells that are
> showing? Thank you in advance for your help.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html