Depending on the version of excel, the way you select the range to copy, you may
find that the hidden rows get pasted as well.
So make sure you select just the range you want to copy
Hit F5 (edit|Goto in xl2003 menus), Special|visible cells only
Go to the other worksheet
Select the cell to paste
Edit|Paste special|paste values
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.
