This is my first visit. I am new to vb. I need some help. I have a site from where i can import data to excel. I need help Data comes in a column . I need to put the data in different column. and every time when the data is refreshed and imported from the website it would be arranged in the same format. That is in different column. Thanks
Thanks Shabbir, Actually , i would be importing the data file from Web site . which are in a single column. To make clear 2009,2,13,1,1,72.32 1) Put the datas in different column 2) here ...... First in the year Second is the month Third is the date Fourth is the first hour of the day Fifth is the first five mins of the hour Sixth is the value 3) Change the fifth column into actual mins 4) Fourth and Fifth column should look like....01:05 in a single column.. 4) And everytime the data refreshes ...it would come in the above format with the No:3 and No:4 condition. Thanks ..