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