| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I pull data from one sheet and place it in another? | Excel Discussion (Misc queries) | |||
| Pull Data from one sheet to another | Excel Worksheet Functions | |||
| How do I use a formula on wk sheet 2 to pull data from wk sheet 1 | Excel Discussion (Misc queries) | |||
| VLookup / pull data from 1 sheet to another | Excel Discussion (Misc queries) | |||
| pull data from sheet two, then fill in the data to sheet one (part | Excel Worksheet Functions | |||
Threaded Mode
