|
Sounds more database-y than excel-esque - could you import it into access/other database?
Long story short, not many functions can edit cells other than themselves, so deleting a row doesn't sound like a function thing. I know nothing about macros, but you/someone might, and I assume they could do the job.
Another alternative; export as CSV, write a quick program in your language of choice to do the dirty work, open up again in excel.
|