I am looking for help writing a MACRO that picks a number from excel and go to web page copy text and paste it into excel
1> We have 4 Application Number in excel sheet
10/689,948
10/458,262
10/618,627
10/845,304
pick 1 by 1 & go to web site (http://portal.uspto.gov/pair/PublicPair)
2> Enter this number & search
3> We get Bibliographic Data
4> Copy Application Type, Filing or 371(c) Date
5> paste this information into excel