Quote Originally Posted by Rick Rothstein View Post
Should the rows with the four dashes and the "G/L Total" text in them be deleted or retained?

Are there any formulas in Column A?

Do you have any formulas on the worksheet anywhere?
For now lets have the four dashes and "G/L Total" text be retained.
No formulas in column A - I import the data from a text file to Excel then I have to reformat it by going through all those lines.
No formulas are all values

Also need to make sure rows are deleted if any cell in column A is empty.

Thanks.