Pasting sub sets.

  • Thread starter Thread starter Rodney
  • Start date Start date
R

Rodney

Using Excel as a Db,
how may I copy / paste a sub set?
I currently get the entire Db pasting
when trying to copy/paste desired rows
(the others being hidden).

Thanks



(e-mail address removed)
 
Rodney,

Before copying, use Edit / Go To.... Special, Visible cells only.

HTH,
Bernie
MS Excel MVP
 
AAaaaaaaaah, so that's where it was hiding.
My help file offered no hints.

May your stockings overflow at christmas with gifts that delight.


| Before copying, use Edit / Go To.... Special, Visible cells only.
|
| HTH,
| Bernie
| MS Excel MVP
 
And if you do it often, you may wish to add that particular icon to your
toolbar, to make it a little easier.

Right click in the toolbar and choose "Customize".
Click on the "Commands" tab,
and in the left window click on "Edit".

In the right window, scroll down almost to the bottom and click on the
"SelectVisibleCells" icon, and drag it to your toolbar.

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
 
Yes, I use it daily RD,
followed your instructions, and have it on the toolbar.
Great!
Thank you very much. :)


(e-mail address removed)





| And if you do it often, you may wish to add that particular icon to your
| toolbar, to make it a little easier.
|
| Right click in the toolbar and choose "Customize".
| Click on the "Commands" tab,
| and in the left window click on "Edit".
|
| In the right window, scroll down almost to the bottom and click on the
| "SelectVisibleCells" icon, and drag it to your toolbar.
|
| --
| HTH,
|
| RD
| ==============================================
| Please keep all correspondence within the Group, so all may benefit!
| ==============================================
|
|
| | > AAaaaaaaaah, so that's where it was hiding.
| > My help file offered no hints.
| >
| > May your stockings overflow at christmas with gifts that delight.
| >
| >
| > | Before copying, use Edit / Go To.... Special, Visible cells only.
| > |
| > | HTH,
| > | Bernie
| > | MS Excel MVP
| >
| >
| >
|
 
Back
Top