I have 2 Data Lists, want to make compare and sort as matched values.
So, I need to find a solution with a formula or maybe Macro.(Formula is preferred)
At the attached file you will find the detail.
Thanks in advance for reply.
Regards,
I have 2 Data Lists, want to make compare and sort as matched values.
So, I need to find a solution with a formula or maybe Macro.(Formula is preferred)
At the attached file you will find the detail.
Thanks in advance for reply.
Regards,
Not sure you could do that with a formula but I could be wrong. In the meantime I've written a macro solution.I need to find a solution with a formula or maybe Macro.(Formula is preferred)
Alf
A macro is “build to order” i.e. what you ask for is what you get. As to that the macro could not solve the different cases is a bit like asking somebody to build you a 5 meter long bridge and then complaining that you can’t use it on a 10 or a 15 meter wide river.your solution was not sufficient to solve the differrent cases.
The better you describe the problem with an uploaded example file the better solution to your problem you will get.
I’ve made an update but also made some changes i.e. I’ve put the 3 cases side by side as this makes it easier for me (after all you get my time and effort free of charge). The macro starts by sorting all lists in the 3 cases in an ascending order before it proceeds to insert the empty cells.
Alf
No, of course not any fee to pay! Just me grumbling a bit! Sorry about that. Hopefully the macro can be of use to you.
Alf
You are welcome but why don't you upload the real file? Unless of course it contains "sensitive" information.
Alf
Ok, best of luck in solving your problem and if you really get stuck you could try uploading your file to one of the sites that lets you upload files for free and post a link in this forum with a request for help.
I've added a link for a number of sites where you can upload to:
http://filesharefreak.com/2009/08/26...g-upload-sites
Regards
Alf
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks