Hi
I am trying to build a template worksheet for my research. I get a file of
logged data per day. I want to be able to copy the logged data from a .CSV
file to a template file. Then separate worksheets will look at the raw data
and import data from certain columns into that worksheet.

The data is not logged in a regular way, there can be 30 cells between
logging intervals or 29 or 31 cells. I can select that every cell in a
column of Worksheet 1 looks at a set cell in the "Raw Data" worksheet. This
will then give me a column consisting of logged data values with zeroes in
between. When I want to graph the data, I don't want the zeroes to appear on
the graph. Is there a way I can import data from one worksheet to another,
where if the value is zero then no value is displayed AND when this data is
then graphed those zeroes don't appear? I can import data and not display
zeroes in the worksheet, I just can't get it to do that AND get the graph to
do what I want.

I would appreciate someone's help.