chandisciple
New Member
Hello Geniuses,
I am awestruck with the solution you are giving in the forum. May be you guys can help me fix this issue sooner than me becoming old.
I have designed a sheet to import data from web. The data imported will have data either true or false as that is the only data present in the website I am using.
I have added a lot of formatting and when i import the data, though the webpage has only one word, it messes up the cells by inserting 1 or 2 more cell and i don't understand why its happening.
So can you help me achieve any ONE of the following,
1) to import the data only to 1 designated cell. (either by adding all the data from the webpage squeeze into one single cell) or just import the first line from the page ( true/false)
2)to analyze the webpage before importing the data and if the webpage has the value TRUE/FALSE then enter the cell value as YES / NO respectively.
Before importing data :
http://postimg.org/image/5q7tonslx/
After importing data :
http://postimg.org/image/r1zgwbpnb/
Regards,
ExcelFAN
I am awestruck with the solution you are giving in the forum. May be you guys can help me fix this issue sooner than me becoming old.
I have designed a sheet to import data from web. The data imported will have data either true or false as that is the only data present in the website I am using.
I have added a lot of formatting and when i import the data, though the webpage has only one word, it messes up the cells by inserting 1 or 2 more cell and i don't understand why its happening.
So can you help me achieve any ONE of the following,
1) to import the data only to 1 designated cell. (either by adding all the data from the webpage squeeze into one single cell) or just import the first line from the page ( true/false)
2)to analyze the webpage before importing the data and if the webpage has the value TRUE/FALSE then enter the cell value as YES / NO respectively.
Before importing data :
http://postimg.org/image/5q7tonslx/
After importing data :
http://postimg.org/image/r1zgwbpnb/
Regards,
ExcelFAN