copy & paste excel - web - excel

This is a copy - paste to web - extract from web and paste to excel task Look at the table in sheet "merged" (column A). There, search for the entries (numbers from column A) where column I says "please enter" (also yellow marked). Copy the value for these "please enter" lines from column A and go to the website [login to view URL] Select the option RX first and then search for the results. On the results website, go to those entries that start with N, followed by the number you entered. Look for the product number. If it matches the value in column F, then enter the approval date. Now check for the following rows where you have to enter values if the page you accessed on the web already contains the product numbers. If not, then not only search for the RX option but also for the OTC and DISC option. Notes: - In case it says "Approved Prior to Jan 1, 1982", then enter "prior 1982" - In case you have a real date, enter it in a typical date format. - Take care that you get the correct number - sometimes numbers have more digits than those you enter: e.g you enter 1234. Then also 12345 and 12346 may be displayed. But only look for 1234! - in case of any doubt - please leave a comment on column J. - If you are not sure about anything, please send me a message.