I need a Macro to Clean Unwanted Data (Rows and Columns) from a Spreadsheet
Posted on 2013-12-18
I am writing a macro to clean up a spreadsheet accounting creates, so that it can be used as an Access table
mvidas already gave me 90% of what i need, but there are a couple of types of columns i still need to delete via the macro
1) I need to delete columns with Headers, but no data below them. For example, Row 1 is a header of a future month, but row 2 below it is blank.
2) I need to delete a column that is a summary column with the header "FYXX"
This would be great as a Related Question, but that feature seems to be removed