I have been looking all over and I can only find macros on how to delete the entire row based on the data in a cell in that row. I'd like something to run through a spreadsheet and delete Frownumber:Lrownumber if the Lrownumber cell has #N/A.
Some addons I am not sure if I would need or not would be to enter the starting row number to begin checking, or start in the row where the cursor is. It might be nice to prompt in the beginning asking which column to search and what to search for....
Some addons I am not sure if I would need or not would be to enter the starting row number to begin checking, or start in the row where the cursor is. It might be nice to prompt in the beginning asking which column to search and what to search for....
