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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Export and Save Only Certain Rows of Data
Considering that you are a novice (your words :-))
the easiest option is to filter (available under DATA menu) on non-zero values, cut and paste them into a new sheet First row of your data should have lables... You can filter on non-zeroes, non-blanks, conditions etc. To automate you can choose the option RECORD MACRO while doing this for the first time and then run the macro... To move towards becoming an expert try to do this on your own using HELP. If unable to do so then let us know. We will give 'excruciating' details :-) Waiting for your response. "Pat" wrote: 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. |
Reply |
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 |