| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying data from 1 worksheet and pasting to another skipping blan
I currently have 4 rows of data that I have an If then statement which
creates data, with empty cells between them. I am looking for a way to paste that info into another worksheet in the same workbook, however I want it to list the item s one after another, and not paste the blanks. Please hep Thanks so muh |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copying data from 1 worksheet and pasting to another skipping blan
Try DataFilterAutofilter.
Filter for non-blanks then F5SpecialVisible cells onlyOK Copy and paste to the other sheet. Gord Dibben MS Excel MVP On Tue, 30 Sep 2008 16:10:01 -0700, Concertgoer wrote: I currently have 4 rows of data that I have an If then statement which creates data, with empty cells between them. I am looking for a way to paste that info into another worksheet in the same workbook, however I want it to list the item s one after another, and not paste the blanks. Please hep Thanks so muh |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatically skipping cells when pasting data | Excel Discussion (Misc queries) | |||
| holding worksheet formats when copying/pasting | Excel Discussion (Misc queries) | |||
| Problems with copying and pasting dates from one worksheet to anot | Excel Discussion (Misc queries) | |||
| Copying and Pasting a Worksheet | Setting up and Configuration of Excel | |||
| Hided values appears when I'm copying/pasting it to other worksheet | Excel Discussion (Misc queries) | |||
Linear Mode
