PLEASE HELP - Pasting Cells to WrkSheet with Hidden Columns

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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 ...........
 
Ahh - and there's the rub. I should have explained better. One worksheet
does not have hidden columns.
 
Thats why I asked in the first reply...........
Can you insert a couple of columns and hide them.
Give it a go.
 
...Make sure u hightlight needed columns 1st. Another solution is hol
Ctrl and select columns, copy and paste
 

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 columns, but not hidden ones 3
Hide columns based on row values 2
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
Pasting data with hidden columns 4
Pasting into protected cells 1
How to copy and paste only visible cells from Excel using vbscript 0
Excel Concatenate with line breaks but ignore blank cells 3
Problem with Pasting into Filtered Fields 2

Back
Top