I need a MACRO that will go down each cell in column A and if it finds data in the cell, it places a dash into the adjacent cell in Column B. Once it finds a blank cell in Column A, the MACRO ends.
I need a MACRO that will go down each cell in column A and if it finds data in the cell, it places a dash into the adjacent cell in Column B. Once it finds a blank cell in Column A, the MACRO ends.
Last edited by El Conquistador; 05-08-2013 at 09:41 AM.
Okay... use below macro:-
Regards,Please Login or Register to view this content.
DILIPandey
<click on below * if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), [email protected]
Try this :
Please Login or Register to view this content.
Last edited by JasperD; 05-08-2013 at 09:29 AM.
Give this a go:
Please Login or Register to view this content.
thank you! that works great!
thanks! That works perfectly
Which one of the three did you use?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks