Hi Everyone,
I have a workbook with a page that is an imported, converted PDF. There are numerous "Blank Rows" and then some other
rows that contain (1 of 7) in column A as well as (2/28/2019, 4:50 AM) in Column B. Then other rows that contain (LOTTERY DAILY IMPORT)
in Column A and (file:///C:/Users/dmgpe/Documents/VeriFone/SRNTemp/rad01E09.tmp...) in column B.
I would like to have a macro that deletes those and then resorts the data.
Unfortunately the rows that contain that data that we want to delete shifts everyday.
I attached a Dropbox link below for the file. I HOPE I did that correctly???
Thanks!
https://www.dropbox.com/sh/i18hy7sqbbpmqbl/AAAN5afkoQTNsd1ymMFajC4ka?dl=0
[TABLE="width: 624"]
<tbody>[TR]
[TD="width: 152"][/TD]
[TD="width: 472"][/TD]
[/TR]
</tbody>[/TABLE]
I have a workbook with a page that is an imported, converted PDF. There are numerous "Blank Rows" and then some other
rows that contain (1 of 7) in column A as well as (2/28/2019, 4:50 AM) in Column B. Then other rows that contain (LOTTERY DAILY IMPORT)
in Column A and (file:///C:/Users/dmgpe/Documents/VeriFone/SRNTemp/rad01E09.tmp...) in column B.
I would like to have a macro that deletes those and then resorts the data.
Unfortunately the rows that contain that data that we want to delete shifts everyday.
I attached a Dropbox link below for the file. I HOPE I did that correctly???
Thanks!
https://www.dropbox.com/sh/i18hy7sqbbpmqbl/AAAN5afkoQTNsd1ymMFajC4ka?dl=0
[TABLE="width: 624"]
<tbody>[TR]
[TD="width: 152"][/TD]
[TD="width: 472"][/TD]
[/TR]
</tbody>[/TABLE]
Last edited: