Mike808
New Member
Excel Ninjas-
So, in my uploaded file, I have some relatively simple clean up's I have to do before importing into my Access Database. I want to create a Macro to do it, but I know for the Macro to be universal (used on any of my spreadsheets), I need to use some if/then statements. The two clean up items are these:
The spreadsheet is actually several spreadsheets together. At the end of each spreadsheet, there is roll up summary info that I do not need. Therefore, I delete these rows including the headers for the next spreadsheet. I would think that I could develop a statement saying "If column "A" cells are null, then delete the row".
The last clean up is there are cells within the spreadsheet that have formatting errors, numbers stored as text and so on. I would like a blanket clean up tool for that.
Any help would be great!! Mahalo from Hawaii!!
Mike808
So, in my uploaded file, I have some relatively simple clean up's I have to do before importing into my Access Database. I want to create a Macro to do it, but I know for the Macro to be universal (used on any of my spreadsheets), I need to use some if/then statements. The two clean up items are these:
The spreadsheet is actually several spreadsheets together. At the end of each spreadsheet, there is roll up summary info that I do not need. Therefore, I delete these rows including the headers for the next spreadsheet. I would think that I could develop a statement saying "If column "A" cells are null, then delete the row".
The last clean up is there are cells within the spreadsheet that have formatting errors, numbers stored as text and so on. I would like a blanket clean up tool for that.
Any help would be great!! Mahalo from Hawaii!!
Mike808