ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to copy only nonblank entries in sheet (https://www.excelbanter.com/excel-discussion-misc-queries/188855-how-copy-only-nonblank-entries-sheet.html)

Ramesh

How to copy only nonblank entries in sheet
 
I will greatfull for the answers from your side.

Gary''s Student

How to copy only nonblank entries in sheet
 
Use AutoFilter to hide the blank entries. The perform the copy/paste.
--
Gary''s Student - gsnu200788


"Ramesh" wrote:

I will greatfull for the answers from your side.


Jim Cone[_2_]

How to copy only nonblank entries in sheet
 

Edit (menu) | Go To... | Special... (button) | ...
Also...
http://www.cpearson.com/excel/newposte.htm
--
Jim Cone
Portland, Oregon USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"Ramesh"
wrote in message
I will greatfull for the answers from your side.

muddan madhu

How to copy only nonblank entries in sheet
 
It might help u...

Ctrl + F, In find what put *
click find all and then Ctrl + A




On May 26, 4:55*pm, Ramesh wrote:
I will greatfull for the answers from your side.



David Biddulph[_2_]

How to copy only nonblank entries in sheet
 
And after that, what is the process to do the copy, Muddan?
--
David Biddulph

"muddan madhu" wrote in message
...
It might help u...

Ctrl + F, In find what put *
click find all and then Ctrl + A


On May 26, 4:55 pm, Ramesh wrote:
I will greatfull for the answers from your side.




muddan madhu

How to copy only nonblank entries in sheet
 
I thought of selecting but i didn't see that copy.... sorry


On May 26, 5:56*pm, "David Biddulph" <groups [at] biddulph.org.uk
wrote:
And after that, what is the process to do the copy, Muddan?
--
David Biddulph

"muddan madhu" wrote in message

...



It might help u...


Ctrl + F, In find what put *
click find all and then Ctrl + A
On May 26, 4:55 pm, Ramesh wrote:
I will greatfull for the answers from your side.- Hide quoted text -


- Show quoted text -




All times are GMT +1. The time now is 09:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com