Results 1 to 3 of 3

Deleting Entire Rows

Threaded View

gavsta Deleting Entire Rows 05-18-2005, 09:01 PM
mangesh_yadav Private Sub... 05-19-2005, 12:35 AM
mangesh_yadav I guess you could make the... 05-19-2005, 12:45 AM
  1. #1
    Registered User
    Join Date
    05-16-2005
    Posts
    13

    Deleting Entire Rows

    GDay Guys,

    I need a favour :-(

    1 - I need a macro to delete entire rows if in column N, cells contain the following "Allocated for Picking"

    2- I also need a macro that will move an entire row to the bottom of the worksheet (sort) if column D or I cells contain either a zero or negative number in it.

    Some body has already written a macro in the attached file for something similar ie moving the entire row to the bottom if column N cells contain anything other than "Available".however I dont really know what to do to change it.

    Cheers and thanks
    Attached Files Attached Files

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