I have attached a sample xls workbook containg column A, which represents account numbers and column B, which represents a numerical number affiliated with the account number. If cells in column A are empty the cell to the left of it in column B will indicate "0". I'm curious if anyone could help me figure out a way to delete the empty cells in column A and the cells in Column B, which indicate "0". Due to the fact that the accounts and/or data change in a given time period I cannot use a filter option and further I'd like to use the compressed data to import into another program if possible. Any suggestions would be greatly appreciated. I thought this might only be possible with either a macro or vba, So I hope this is the appropriate forum. Thanks again for any assistance in this matter!
Bookmarks