Prev: Find/Replace Numbers stored as Text drops zeros
Next: Viewing text 2003 vs. 2007
From: Ed on 21 Apr 2010 16:21
I figured out how to filter the data and to select for all non-blank cells
and then copy the data to my chart data spreadsheet. But I continue to add
additonal data. Will I have to copy and paste each time I add new data or is
there a formula that I can use to automate the process?

"Paul C" wrote:

> Set up Filter (Data-Filter) for you entire range of data
>
> Then select to show all non-blanks in column C
>
> Once this is done select the data range and copy-paste to a
> new sheet. The rows with Column C blank are not selected and do not paste.
>
>
> --
> If this helps, please remember to click yes.
>
>
> "Ed" wrote:
>
> > How do I skip a blank cell? I have a column of dates (Col A) and a column of
> > numbers (Col C). Col C has irregular blanks. I want to copy these to another
> > spreadsheet without the blanks in Col C and without the corresponding dates
> > in Col A. My purpose is to creat a column chart without the gaps caused by
> > blank cells. The IF function will return a blank for a blank but I want to
> > skip the blank.
First  |  Prev  | 
Pages: 1 2
Prev: Find/Replace Numbers stored as Text drops zeros
Next: Viewing text 2003 vs. 2007