Copy & Paste with Subtotals

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

Guest

I have a list on which I have used the subtotal command on the Data menu. I
have then used the outlining buttons on the left to show the detail (rows)
that I want. I would like to copy & paste (value only) these so a separte
sheet but when I do I find I have copied all the hidden rows as well. Is
there any way to do what I want without resorting to VBA? Apologies if I
have missed the blindingly obvious.

Many thanks, Peter.
 
Hide your details
select the range to copy
edit|Goto|special|Visible cells only
edit|copy
off to the other sheet
edit|paste
 
Dave,

Magic - worked perfectly. Thanks for the very quick reply much appreciated.

Peter
 
Back
Top