Hi
I am new to excel and i have a situation where i have a pan data in column A... say A1, A2 and so on. I want these PAN numbers to pull out data from the website "https://www.mahaonline.gov.in/NSDG/PANDetails/MahaonlinePAN.aspx" and put the result on other sheet in same work book, each PAN should through result in diff sheet in same work book.
PAN number to try is "APFPR8862R" - PAN is in format of 5 characters followed by 4 number with last one character.
I tried this by importing data from website but was of no help.
Thank you in advance
I am new to excel and i have a situation where i have a pan data in column A... say A1, A2 and so on. I want these PAN numbers to pull out data from the website "https://www.mahaonline.gov.in/NSDG/PANDetails/MahaonlinePAN.aspx" and put the result on other sheet in same work book, each PAN should through result in diff sheet in same work book.
PAN number to try is "APFPR8862R" - PAN is in format of 5 characters followed by 4 number with last one character.
I tried this by importing data from website but was of no help.
Thank you in advance
Last edited: