I'm a novice to VBA and macros but I'm trying to create a simple macro to eliminate blank or text rows from hundreds of rows of data provided by my local utility company. In the attached sample file, say I have the cursor positioned at A5. What I want the macro to do is go down the column (END + DOWN), and then delete the three rows that follow (Rows 29-31), then keep going to the next spot (END + DOWN) and delete the three rows after that (56, 57, 58) etc. But I don't want to specify specific row numbers because I want to use this "generically" such that those three rows are deleted regardless of their row number.
I'm sure this is simple enough if you know what you're doing. But I don't.
Thanks
Bookmarks