Deleting Entire rows thorughout the whole data set

[sx200n]

Hello,

Basically I need to remove lots of rows from a transaction report on a regular basis. I have attached an example of how it looks. I do have a macro that I quickly entered but this only seems to remove parts and as a result throws the whole file out of sync.

I only need to keep the entire row on cases where it has a date in Column A. All relevant data in the next two rows (without a date - and before the next date) are useless to the report I compose so I need the entire workbook to have them removed.

I have attached a before and after snippet to show how I need it to look. The 'before' attachment is exactly what I receive from our ancient accounts system. The 'Final' attachment is ideally how it needs to look in the end.

Thankfully the transaction output I get each week is always in the same format - just with varying rows depending on how many transactions are made within a specified time period. So ideally I need a macro that will work regardless of how many rows of data there may be.

Any help would be greatly appreciated..

[Mumps1]

It seems that what appear to be blank cells in column A are not blank. They contain spaces which of course are not visible. Therefore, the following macro first removes the spaces and then deletes all the blank lines.

Please Login or Register  to view this content.