View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
bpman bpman is offline
external usenet poster
 
Posts: 2
Default can I pull only data from a sheet greater then 0

Dear Expert

I'm trying to pull data from a seperate sheet to another to create
labour coverage chart. I would like to pull it over without bringin
any rows with 0 values so that there are no empty spaces in th
chart. when i try an if equation to do this it just doubles the dat
between 0's
the data would originally look like thi

name in ou
joe 9:00 15:0
dav
mike
chris 12:00 20:0

I would like to pull the data to the chart page so that it come
across to a set sized data table like thi

name in duratio
joe 9:00 6:0
chris 12:00 8:0

I would appreciate anyone assistance in this matter