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



(e-mail address removed)
 
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. :)


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

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.

Ask a Question

Top