Sorry for the size of this file. I made it as small a sample as I thought would show my problem.
I'm having a problem. If you look at the "export" sheet in the attached spreadsheet you will notice 6 rows of data. Behind the scenes each cell on this sheet has a "if" statement. The if statement is trying to only display those records that meet a certain criteria based on data it finds on the "data" sheet.
Visually this sheet looks like if you save this sheet as text you will end up with a text file that has 6 rows in it. However when you do this you end up with 6 records and 94 rows showing as just carriage returns. These extra rows are the hidden (should be blank) rows created from the If statement in those rows.
How can I construct a if statement so when I save this sheet as a text file only the "visible" rows get exported.
In normal use data starts at the first row and goes down to some point and then from there it's "blank". I will not be dealing with random blocks of data with blanks in between.
Thanks in advance.
Bookmarks