+ Reply to Thread
Results 1 to 1 of 1

Deleting all rows that meet a certain condition, for multiple files

  1. #1
    Registered User
    Join Date
    01-31-2009
    Location
    Romania, Eastern Europe
    MS-Off Ver
    Excel 2007
    Posts
    25

    Deleting all rows that meet a certain condition, for multiple files

    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.
    Last edited by pike; 03-30-2011 at 04:10 PM. Reason: added link

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1