PLEASE HELP - Pasting Cells to WrkSheet with Hidden Columns

R

Rob the Winer

I have tried everything I can think of - is there anyway to paste cells from
one worksheet to another and not have data paste into hidden columns? ie
Pasting cells from 3 columns (A, B, C) into a worksheet where columns C and D
are hidden. The desired result is date pastes into Columns A, B, and E since
C and D are hidden. I can't find anything (like paste special) that will
alow this operation to work as described.
 
R

Rob the Winer

Yes, not sure why you are asking. I have tested this with blank worksheets
as well.
 
B

bill k

if the structure of sheet1 is the same as sheet 2 the copy paste will
work fine.

you shouldn't have any data in columns c and d in sheet 1 because they
are hidden ...........
 
R

Rob the Winer

Ahh - and there's the rub. I should have explained better. One worksheet
does not have hidden columns.
 
B

bill k

Thats why I asked in the first reply...........
Can you insert a couple of columns and hide them.
Give it a go.
 
V

verseemcee

Edit->GoTo->Special...->Visible Cells Only. Copy and paste into ne
workseheet
 
V

verseemcee

...Make sure u hightlight needed columns 1st. Another solution is hol
Ctrl and select columns, copy and paste
 
Top