chandisciple
New Member
- Joined
- Jun 2, 2010
- Messages
- 4
Hello Geniuses,
You guys may help me fix my problem.
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 someone 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 analyse the data from web and if the value in the web is true, input the value in cell1 as yes or false .
3)to analyse the webpage and if the webpage has the value TRUE/FALSE then enter the cell value as YES / NO respectively.
Before importing data :
View image: before
After importing data :
View image: after
Regards,
ExcelFAN
You guys may help me fix my problem.
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 someone 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 analyse the data from web and if the value in the web is true, input the value in cell1 as yes or false .
3)to analyse the webpage and if the webpage has the value TRUE/FALSE then enter the cell value as YES / NO respectively.
Before importing data :
View image: before
After importing data :
View image: after
Regards,
ExcelFAN
