HI ,,I have one excel sheet where the description of several points are in one column say point of chainage 0+070 having its x coordinates y coordinates ,z value and the location of side are in one column i need in separate column ?how to do that in vb code ?
non VBA solution
b2=and drag down.
Please Login or Register to view this content.
f2=and drag across.Please Login or Register to view this content.
the blue cells are manualy filled.
see the attached file.
Last edited by oeldere; 08-23-2014 at 03:48 AM.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
I amented (expanded) the file.
See the new added file.
or try below,
Please Login or Register to view this content.
Regards,
Nandkumar S.
---------------------------------------------------------------
Don't forget to Click on * if you like my solution.
can it be done in one click ? Because chainage and side are not coming automatically.After coming of x y and z in separate column i have to put chaiange and side manually by searching each X OR Y for searching of which chainage and side it is located because chainage and side can be changed(only chainage is changing here but side also can be changed) ,that can be very time taking matter .can it be done by vba just by one click?
yes Nandkumar sir it is solved thanks for your help.
Glad to help you
did you look at the file in #3?Please Login or Register to view this content.
There are both automatic filled in the columns.
Please reply.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks