Export non Zero data to another Workbook

[iczy]

Hello,

I have two worksheets:
1) Raw data (number of rows variable)
2) Data to export

On worksheet 2, I have IF formulas so that if there's no data on the cell in Sheet 1, 0 or " " value returns - Since I dont know how many rows Raw data might have.

Now the problem is, how could I export Sheet 2 to another Excel or CSV file, so that the null values are not included? It creates a problem to the system I'm trying to upload since it read those lines that I dragged the IF formulas down in Sheet 2.

I attached a sample of my file.
Thank you for the help.

[Sisyphus]

Hi,
Have tried Autofilter? It should be possible to filter out the zero items and save the remainder to another workboo or sheet.

[Sisyphus]

Hi,
I looked at your file now and wonder about the use of your sheet 2. You are copying data of Text format. Well, apparently the data you get are in Text format, so no harm is done, but I might suggest a better formula if I would have a better understanding of what, exactly, you are trying to do. If the purpose is to eliminate blanks my earlier suggestion could be worked on Sheet 1 and you would never need any formulas and never have any blank rows in Sheet 2.

On the other hand, if you are satisfied with the performance of your Sheet 2 and all you want is to remove formulas that return no data you may try to Copy and Paste Special / Values. That would replace all formulas with their values, meaning, if the value a formula returns is a blank you get a real blank. If you then need a way to remove the blanks or zeros you can use Autofilter to do the job.