+ Reply to Thread
Results 1 to 1 of 1

Cutting row and pasting into new sheet based on criteria

  1. #1
    Registered User
    Join Date
    07-13-2011
    Location
    Melbourne Australia
    MS-Off Ver
    Excel 2003
    Posts
    4

    Cutting row and pasting into new sheet based on criteria

    Hi guys,

    I have a pretty simple query but so far i have been searching the net and have been unable to gather my answer.

    I am running a pretty basic spreadsheet that compiles basic stats as to where applications are within my process. New applicants, background checks """, """ and closed,

    what i require the sheet to do is, when the value in the (G) column ="closed" i need that entire row to be cut and pasted into sheet 2 and for the remaining data on sheet 1 to fill the blank space on sheet 1.

    I have attached the worksheet so you can get a clear picture of what i need

    i am an absolute noob when it comes to VBA so any help is appreciated.
    Hopefully someone can shed some light on the issue..
    thanks heaps,
    Attached Files Attached Files
    Last edited by goose1000; 07-19-2011 at 12:46 AM. Reason: forgot to attach document :P

+ 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