LinkBack URL
About LinkBacks
Merge data from two columns using Distance.
Merge data from two columns using Distance.
Last edited by sanju2323; 02-28-2015 at 02:00 AM.
Hi sanju,
Run the Macro on the attached sheet and it will do what I think you want.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
MarvinP Sir, File shown error -
Protected view office has detected a problem with this file. Editing it may harm your computer.
Error - Copy.jpg
Please solve problem and attach again copy
Hi sanju,
I just ran the code again and it worked fine on my Excel 2013. I simply recorded a macro and didn't edit it. I think the problem is on your end. What is ERTAT? Perhaps you are trying to run it off a server or your Virus protection software is giving you the message?
MarvinP Sir, or Please give me VBA CODE
ERTAT? program is Draw Table excel to autoCAD
Here is the recorded macro to do your problem.
Please Login or Register to view this content.
sir This code works pretty awesome. But give to me a slight improvement.
1) i need result "K3" to "O".
2) No need result color format as simple format.
Hi Sanju,
Instead of giving you an answer it is time you learn how to answer this problem yourself. Read:
http://www.contextures.com/excel-macro-record-test.html
Here were my steps.
1. Copy the first range
2. Paste it after the second range on the right
3. Copy the second range
4. Paste it BELOW the range just pasted in step 2 above
5. Sort the new combined range by the time colum
Record the above steps and you will have exactly the macro I gave you.
You can then decide where to paste your first range.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks