Missing data

[OCM]

Greetings,

I;m using Excel 2007 and I have a very big excel file that was imported from access database and has a lot of blank rows that I tried to delete. I used the following Excel built in method :

F5 ->Special ->Blanks (blank cell will be highlighted)
Ctr+ 9 to hide the rows -> select visible command (to select only visible rows)

Ctr +C and Ctr+V to a new worksheet.

It works fine, except I noticed for few columns in the end, the associated records were missing.

can this be corrected w/o recording a Macro?

By the way, how do you attach a sample file to the forum?

Thank you in advance.


OCM

 

[SkipVought]

hi,

I'd turn on the Auto Filter and select BLANKS to hide all rows with data.

Thne select the BLANK ROWS, right-click and DELETE.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}