Pasting sub sets.

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



[email protected]
 
B

Bernie Deitrick

Rodney,

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

HTH,
Bernie
MS Excel MVP
 
R

Rodney

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
 
R

RagDyer

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!
==============================================
 
R

Rodney

Yes, I use it daily RD,
followed your instructions, and have it on the toolbar.
Great!
Thank you very much. :)


[email protected]





| 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
| >
| >
| >
|
 
Top