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,
Bookmarks