How do I copy information and skip hidden cells?
Select the range
edit|goto|special|visible cells only
edit|copy
off to the other sheet
edit|paste
If you have formulas that you want to keep, I think you'll have to copy|paste
each visible area separately.
unfrgvn82 wrote:
Just looking for some help to copy visible information from one page to
another without including hidden information. Example: Copy rows 1-10
excluding 7,8 which are hidden.
--
Dave Peterson
|