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.

can you insert a couple of columns in the first sheet as well and hide
them?


--
bill k


------------------------------------------------------------------------
bill k's Profile: http://www.excelforum.com/member.php...nfo&userid=821
View this thread: http://www.excelforum.com/showthread...hreadid=469901

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

"bill k" wrote:


can you insert a couple of columns in the first sheet as well and hide
them?


--
bill k


------------------------------------------------------------------------
bill k's Profile: http://www.excelforum.com/member.php...nfo&userid=821
View this thread: http://www.excelforum.com/showthread...hreadid=469901

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 ...........


--
bill k


------------------------------------------------------------------------
bill k's Profile: http://www.excelforum.com/member.php...nfo&userid=821
View this thread: http://www.excelforum.com/showthread...hreadid=469901

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

"bill k" wrote:


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 ...........


--
bill k


------------------------------------------------------------------------
bill k's Profile: http://www.excelforum.com/member.php...nfo&userid=821
View this thread: http://www.excelforum.com/showthread...hreadid=469901

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


--
bill k


------------------------------------------------------------------------
bill k's Profile: http://www.excelforum.com/member.php...nfo&userid=821
View this thread: http://www.excelforum.com/showthread...hreadid=469901

Edit-GoTo-Special...-Visible Cells Only. Copy and paste into new
workseheet.


--
verseemcee
------------------------------------------------------------------------
verseemcee's Profile: http://www.excelforum.com/member.php...o&userid=27816
View this thread: http://www.excelforum.com/showthread...hreadid=469901

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


--
verseemcee
------------------------------------------------------------------------
verseemcee's Profile: http://www.excelforum.com/member.php...o&userid=27816
View this thread: http://www.excelforum.com/showthread...hreadid=469901