Results 1 to 3 of 3

Thread: missing data

  1. #1
    Join Date
    Sep 2002
    Location
    USA
    Posts
    66

    Unanswered: missing data

    Greetings,
    I use Excel & 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 there is data missing for the columns highlighted in red on my sample attachment.

    can this be corrected w/o recording a Macro?

    Thanks,
    Attached Files Attached Files

  2. #2
    Join Date
    Jan 2002
    Location
    Bay Area
    Posts
    511
    My solution is to import the correct data from Access so you will not have the clean-up problem in Excel.
    Do you own the data base so that you can fix the process that does the exporting? If not, can you link to the data base from a new data base and create your own query that excludes all the blanks you see in Excel?

    I would export clean delimited data, using a delimiter character not found in the data (such as the tilde ~ character) into a text file, and import that into Excel.

    Good luck.
    Jerry

  3. #3
    Join Date
    Sep 2002
    Location
    USA
    Posts
    66
    Thank you for your reply. I recorded a macro in Excel and it is working now.


    Regards,

    OCM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •