Macro to format a worksheet help

[alexduy]

Hi Excel Experts,

I need help writing a Macro that would delete any rows that are not empty in column “A”, from cell A8 to the bottom of the spreadsheet. Attached is a worksheet with two tabs, “Original” and “Formatted”. Please let me know if it’s possible. If possible, the macro will not delete any cells in column A that has "X". Also, the data is never the same.

Thanks

[AB33]

What does “Formatted” sheet do? Is this the expected result?

[alexduy]

yes, it's the final result.

Thanks.

[tehneXus]

try

Please Login or Register  to view this content.

[alexduy]

Doesn't work =(.

[AB33]

Try the attached.

[tehneXus]

Any errors? You have to have the sheet activated which is going to change and "Inactive" is in A7..
try instead

Please Login or Register  to view this content.

[AB33]

If you want a filer which is I am not a big fun of it.

Please Login or Register  to view this content.

[alexduy]

Doesn't work =(. This is how the real worksheet looks like, see if you fix the macro to work on this worksheet.

[AB33]

"Doesn't work"

Does not help either.

What does not work? You have attached an output sheet and you have 3 codes and none of them work.
All of them work as per attached.

[alexduy]

The NotBigFun code work perfectly. It's exactly what i'm looking for.

Thanks!