First off hey yall! glad to be a part of the forum, already spent quite a bit of time going through the forum and quite impressed at some of the ingenuity I have seen. Anyways on to my problems....

Question 1: How to auto convert cells value to a hyperlink.
Here is a basic rundown of what I want to do.
If ($Value = MS**-***) {
then convert link to "http://technet.microsoft.com/en-us/security/bulletin/MS**-***"
} ELSE {
Set link to www.google.com/
}

Question 2: Moving rows of data based on cell value.
In my document column K is a drop down menu that you can either select open or closed. I want to make it so if I set it to closed it will move it to worksheet 2 (title:CLOSED) and append a Date Stamp to column L. of the row. Also if i open it again in CLOSED it will move back to OPEN.