| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to copy only nonblank entries in sheet
I will greatfull for the answers from your side.
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy Unique Entries | Excel Worksheet Functions | |||
| Copy calendar entries without overwriting date? | Excel Discussion (Misc queries) | |||
| How do I copy a table w/o certain entries? | Excel Discussion (Misc queries) | |||
| Sheet-to-sheet auto-entries of text | Excel Worksheet Functions | |||
| Require a cell to be nonblank if another cell is nonblank | Excel Discussion (Misc queries) | |||
Linear Mode
