Need a vba program , select same diameter with it's lenght and number a copy it in color columns .
diameter 10 and 12 missing in main base , so I need if some of diameters missing just skip it and go to the next one .
Need a vba program , select same diameter with it's lenght and number a copy it in color columns .
diameter 10 and 12 missing in main base , so I need if some of diameters missing just skip it and go to the next one .
Last edited by sergiu_ciuhnenco; 01-25-2015 at 01:24 PM.
Thanks for the title change
Last edited by FDibbins; 01-25-2015 at 01:45 PM.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
sergiu_ciuhnenco, Welcome to the Excel Forum.
It looks like you are on-line. As soon as you change to a descriptive title, I can post a solution.
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
Sorry !!! I am Forum Newbie .
In the attached, I replaced all your Merged cells with Center Across Selection. This code did what you want.
Please Login or Register to view this content.
hi mikerickson, probably you misunderstood me , I want to find and copy cells for example : Range (B2:D3) to L2;
Range (B4:D31) to O2 .....[ to search each diameter with its length and number and copy it to the columns that I mentioned ( L2 ; O2; R2 )....
In range B2:D67 miss diameter 10 , 12, 28 and 32 but sometimes it could be so I want if some of diameters are missing to skip it and go for the next one
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks