Hi everyone
I have a bunch of spreadsheets in a folder, and all of them need to have the following operation done upon them: whenever a cell in the C column is smaller than -1000 or greater than 1000, then the whole row that contains that cell gets deleted.
Any macro that could do this for all files (and subsequently save&close them)? Also, if it's not too complicated, is there a way for the macro to create a log file with all the rows that were deleted for each file?
Anticipated thanks!
(sorry for cross posting this question on another forum as well, I just need to find a solution to this quite soon)
Apologies for that, forgot I had to also give the link in addition to mentioning the cross-post. The links are http://answers.microsoft.com/en-us/o...&page=1#footer and http://www.mrexcel.com/forum/showthread.php?p=2664698 (and it looks like someone came up with a solution). Sorry again for cross-posting, I was qiute pressed to find a solution.
Bookmarks