| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Export and Save Only Certain Rows of Data
Is there a way that I can have Excel automatically export only certain rows
of data and then save this data as a new spreadsheet? Here's an example: Company_ID Job_ID Job_Title Job_Category 374 9031 Physical Therapist 0 374 7824P Orthopedic Surgery Surgery 374 LT 3004 Family Practice Family Practice 374 7769 Intensive Care 0 In the example above, the 4th column has two fields with a value of zero. What I would like to do is have a way to export only rows that DO NOT have a value of zero and then have this saved as a new Excel file. Doable? If so, please explain in painful detail as I'm pretty much a novice with Excel. Thanks for your help and tips. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to export to a CSV but my file has more than 65536 rows | Excel Discussion (Misc queries) | |||
| Cannot save or export XML data?? | Excel Discussion (Misc queries) | |||
| Export Rows individuall to a new file? | Excel Discussion (Misc queries) | |||
| Export (or save as) .csv with text delimiters | Excel Discussion (Misc queries) | |||
| Save as or export with values only | Excel Worksheet Functions | |||
Threaded Mode
