Transfering Rows to Between Sheets

[MVictorH]

Hello, I am new to excel and trying to use it to help organize files. My office is very "hard-copy" minded and handles many applications each week with scribbles all over them as they are passed around the office. I am trying to make some excel sheets to reduce this. Here is one of the first:

Basically, I would like excel to automatically take a row of information for the "Pending" sheet and send it to the next open row on the "Certified" or "Waived" sheets based on the "Status" value (column E, there is a drop-down with the "Certified" and "Waived" options). Once the data is transferred, I would like the row deleted from the "Pending" sheet. I have tried a few things, but I keep getting random blank rows in the "Certified" and "Waived" sheets.

Any help would be greatly appreciated!! I have included a sample of what I have so far.

[stnkynts]

Put this under the code for the Pending worksheet:

Please Login or Register  to view this content.