Greetings,
I would like to copy some specific information from a Website to Excel Sheet. I need to copy the Company Name, Address, Phone, Business Details (About Us), Contact Person into Excel Table format.
This is the link for Website : http://office-supplies.exportersindia.com/furniture/
If you goto "View Details" it would take you to below link:
http://www.exportersindia.com/company/566062/Ideal-Worldwide/
I started with manually copying and pasting into Excel Sheet, however, this is a time consuming process and requires lot of patience.
One of my friends gave me a shortcut of doing this. He asked me to copy the entire page into Sheet1 and using a simple formula (ex. =Sheet1!B16) copy the content into another sheet. This seems to be working excellent with me if everytime the Webpage details gets copied to exact Excel Cell. Say for example if I am copying the entire Webpage to Excel Sheet (A1), it will dump almost entire Website everywhere in the Exccel Sheet. If the Supplier details gets pasted to exact cell everytime then this formula works fine with me.
The problem here is, if I copy the web content into Excel Sheet it may not be necessarily get into the Cell I want to recall. Sometimes Company Name goes to A124 and for a different Supplier (when copying the entire page into Excel) may goto A126.
Is there anyway I can copy the entire page into Excel Sheet and then pull the required information to another Sheet?
I would really apprecaite your support.
I would like to copy some specific information from a Website to Excel Sheet. I need to copy the Company Name, Address, Phone, Business Details (About Us), Contact Person into Excel Table format.
This is the link for Website : http://office-supplies.exportersindia.com/furniture/
If you goto "View Details" it would take you to below link:
http://www.exportersindia.com/company/566062/Ideal-Worldwide/
I started with manually copying and pasting into Excel Sheet, however, this is a time consuming process and requires lot of patience.
One of my friends gave me a shortcut of doing this. He asked me to copy the entire page into Sheet1 and using a simple formula (ex. =Sheet1!B16) copy the content into another sheet. This seems to be working excellent with me if everytime the Webpage details gets copied to exact Excel Cell. Say for example if I am copying the entire Webpage to Excel Sheet (A1), it will dump almost entire Website everywhere in the Exccel Sheet. If the Supplier details gets pasted to exact cell everytime then this formula works fine with me.
The problem here is, if I copy the web content into Excel Sheet it may not be necessarily get into the Cell I want to recall. Sometimes Company Name goes to A124 and for a different Supplier (when copying the entire page into Excel) may goto A126.
Is there anyway I can copy the entire page into Excel Sheet and then pull the required information to another Sheet?
I would really apprecaite your support.